Any good with Microsoft Excel?

[Taylorman]

This is totally not related to boats but I have looked everywhere and can't find the answer to this question. Im trying figure out how to make this if formula work in excel. I need to do an if statement where the logical test is if a value is between 0 and 20000, return a value. My problem is I don't know how to write it. I have tried this formula if(B15=1<20000,B15*.055,0). Im trying to say in my formula, if b15 is greater than 1 and less than 20000, multiply the number in b15 by .055, otherwise return a value of 0. My formula is not correct. How do I get the logical test to check for a value between 1 and 20000. Sorry for the spam but this is driving me nuts.

[mickeyfinn]

Try this. Input your range of numbers into Column A. Paste this formula into column B. The results should be correct now in column B. Let me know if this doesn't work for you.
=IF(AND(1<A1, A1<20000), A1*0.055,0)

[Petrofied]

I think this is what you are looking for
=IF(B15>20000,0,IF(B15<1,0,B15*0.055))

[mickeyfinn]

Two different ways to get to the same end point. Take your pick