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

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

"Kerri Olsen" wrote:

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

Hi Kerri,

Look he

http://www.mcgimpsey.com/excel/variablerate.html


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Kerri Olsen" wrote in message ...
| IF CELL A2 IS LESS THAN 100 = $25.00, IF GREATER THAN 100= $25.00 + THE
| AMOUNT OVER 100 *.05
| --
| Kerri

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

"Kerri Olsen" wrote:

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

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

http://dts-l.org/goodpost.htm
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Kerri Olsen" wrote in message
...
IF CELL A2 IS LESS THAN 100 = $25.00, IF GREATER THAN 100= $25.00 + THE
AMOUNT OVER 100 *.05
--
Kerri

Thank you this worked.
--
Kerri


"FSt1" wrote:

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

"Kerri Olsen" wrote:

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