FORMULA NEEDED

[Guest]

IF CELL A2 IS LESS THAN 100 = $25.00, IF GREATER THAN 100= $25.00 + THE
AMOUNT OVER 100 *.05

 

[Guest]

try
= 25+max(0,(A2-100)*.05)

 

[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

 

[Guest]

hi,
try this...
=IF(A2<=100,25,(A2-100)*0.05+25)
regards
FSt1

 

[Don Guillett]

While you are at it have a look here, especially the part about typing in
CAPS

 

[Guest]

Thank you this worked.
--
Kerri

hi,
try this...
=IF(A2<=100,25,(A2-100)*0.05+25)
regards
FSt1