IF Then formula 1

[caniwi]

I want a formula to calculate based on the value being in a range.

something like:

if cell A1 is >= 1000 & <= 2000 (or A1 is between 1000 & 2000) then A1 * 0.2 else 0.

I have no idea how to write it.

Thanks

 

[Dreamboat]

Here's an idea.

=if(and(a1>=1000,a1<=2000),a1*2,0)
Anne Troy

http://www.TheOfficeExperts.com