Team,
Need assistance again with the attached worksheet which is an sales incentive plan. I need cell B69 to represent the amount in b68 unless neither b30 or b99 are > 0. In other words if even 1 of the cells b30 or b99 come back positive, you get the amount in b68. If it comes back 0 in both cells b30 and b99, then they get 0. I hope that makes sense.
In B69, use this.
Formula:
=IF(AND(B30>0,B99>0),B68,0)
-------------
Tony
I tried substituting the and for or and it seems like that may have worked.
BeachRock,
It is still returning 0 if only 1 is negative. If either one of them is positive they should get b68. Thanks for your help
Ah, sorry I thought you had said that if both were zero or less and not if one or the other. Yes, then OR should work as you need it to.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks