Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How do I use 10<J3<20 in an IF Formula?
0 views
Skip to first unread message
sgibson
Aug 30, 2006, 11:27:01 AM8/30/06
to
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?
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?
Ron Coderre
Aug 30, 2006, 11:31:02 AM8/30/06
to
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
bplu...@gmail.com
Aug 30, 2006, 12:08:19 PM8/30/06
to
Hello,
=IF(ABS(J3-15)<5, "in interval 10-20", "not in interval 10-20")
Regards,
Bernd
0 new messages