How do I use 10<J3<20 in an IF Formula?

S

sgibson

I am trying to use an IF function to calculate my commission. All I can get
it to do is if J3<20, but I need to get it to be 10<J3<20. It won't let me do
it. How can i get this to work?
 
R

Ron Coderre

Try something like this:

=IF(AND(J3>10,J3<20),do_this,otherwise_do_this)

Example:
=IF(AND(J3>10,J3<20),A1*20%,A1*15%)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP
 
B

bplumhoff

Hello,

=IF(ABS(J3-15)<5, "in interval 10-20", "not in interval 10-20")

Regards,
Bernd
 
Top