new member please be gentle
In short: I have an if statement that I would like to return "0" when it divides by 0 instead of "#DIV/0!"
The formula is: =IF(T5/T10>V5,25%*W5,0)
T5 = $Revenue
T10 = No. of customers
V5 = $revenue threshold
W5 = $profit
So If the average revenue (T5/T10) is greater than a certain number (V5) , take 25% of profit (W5), if we don't meet that threshold, show 0.
I would like the formula to say If the average revenue is greater than a certain number, take 25% of profit, if we don't meet that threshold, show 0 AND if there are 0 customers show 0 instead of #DIV/0!.
Any and all help is much appreciated. Than you
Bookmarks