I would like to hide cells where the formula displays "FALSE".
Turning the text white would be sufficent but I can't get it to work with conditional formatting.
I tried using ISERROR but FALSE isn't really an error so that didn't help. I supect there is a way to make a formula read FALSE as text but I don't know how to do that.
I really just want to supress FALSE from displaying.
The actual formula I'm using is
=IF(D8>0,IF($E$4>0,(D8-AB8)/$E$4,ABS(AH8)))
D8 = quota
$E$4 = # days left in the month
AB8= mtd commissions
AH*= +/- quota
So what is really says is, if you have a quota and there are still days left in the month, subtract your current commissions from your quota and divide that by the # of days left in the month to get your target for today. On the last day of the month the # of days left = 0 so instead of dividing by 0 I used the IF statement to just give me the current total of whatever they are ahead or behind. The FALSE is resulting from people who have no quota assigned to them.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.