How do I use 10<J3<20 in an IF Formula?
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?
|