Bob --

If your sales are in A1, then here's a formula that works:

=IF(AND(A2100000,A2<200000),A2*1.25,"")

You'll need to add whatever happens if it's outside the range.

HTH

"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.