Try:
=IF(A1200000,"",IF(A1<100000,"",IF(A1=100000,A1* 0.25)))

where A1 is your data.
Above formula will give a result if A1 is equal to 100,000 (min)and 200,000
(max)also.

If data is above or below range then nothing is displayed.

Corey....

"MINI MART" <MINI wrote in message
...


"BobVA" wrote:

Hello,

I'm ok in Excel but I need to write a formula to calculate that if sales
are
greater than 100,000 but less than 200,000 multiply that number by 25%.
Probably real easy for some of you but I can't quite get it to work. Any
suggestion is welcome.