G
Guest
IF CELL A2 IS LESS THAN 100 = $25.00, IF GREATER THAN 100= $25.00 + THE
AMOUNT OVER 100 *.05
AMOUNT OVER 100 *.05
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
try
= 25+max(0,(A2-100)*.05)
= 25+max(0,(A2-100)*.05)
N
Niek Otten
Hi Kerri,
Look here:
http://www.mcgimpsey.com/excel/variablerate.html
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
| IF CELL A2 IS LESS THAN 100 = $25.00, IF GREATER THAN 100= $25.00 + THE
| AMOUNT OVER 100 *.05
| --
| Kerri
Look here:
http://www.mcgimpsey.com/excel/variablerate.html
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
| IF CELL A2 IS LESS THAN 100 = $25.00, IF GREATER THAN 100= $25.00 + THE
| AMOUNT OVER 100 *.05
| --
| Kerri
G
Guest
hi,
try this...
=IF(A2<=100,25,(A2-100)*0.05+25)
regards
FSt1
try this...
=IF(A2<=100,25,(A2-100)*0.05+25)
regards
FSt1
D
Don Guillett
While you are at it have a look here, especially the part about typing in
CAPS
CAPS
G
Guest
Thank you this worked.
--
Kerri
--
Kerri
FSt1 said:hi,
try this...
=IF(A2<=100,25,(A2-100)*0.05+25)
regards
FSt1