Use the And function:

=if(and(a1100000,a1<200000),a1*1.25,valueiffalse)

--
Regards,
Fred


"BobVA" wrote in message
...
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.