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?

Try something like this:

=IF(AND(J310,J3<20),do_this,otherwise_do_this)

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

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

XL2002, WinXP


"sgibson" wrote:

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?

Hello,

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

Regards,
Bernd