Hi all,
I currently have a nested IF statement that outputs a value that can either be a positive or negative integer.
When the IF statement outputs a negative integer i want to convert that into zero, so that it doesn't incorrectly affect some revenue calculations that depend on it.
Essentially i'm looking for:
IF
(IF Statement) <= 0, output 0,
Else
Output IF Statement.
I have attached the worksheet with the problem in it.
- The row containing my current formula (that I want to improve) is coloured orange
- The row containing the subjects of my formula are coloured blue
Thanks in advance.
Zak
Bookmarks