How do I use 10<J3<20 in an IF Formula?
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? |
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? |
How do I use 10<J3<20 in an IF Formula?
Hello,
=IF(ABS(J3-15)<5, "in interval 10-20", "not in interval 10-20") Regards, Bernd |
All times are GMT +1. The time now is 08:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com