Forum Discussion
Solved
Help with a Conditional Formula
I have written an Excel Spreadsheet that calculates a currency value in various cells based around the tax scales as income increases. The result of the sheet (total tax payable) requires the additio...
Andrew58 One simple method would be to use the MAX function to return the maximum value between the calculation and zero. For example:
=MAX(calculation, 0) =MAX(A1-B2, 0) =MAX(8-10, 0) =MAX(-2, 0) =0
Andrew58 One simple method would be to use the MAX function to return the maximum value between the calculation and zero. For example:
=MAX(calculation, 0)
=MAX(A1-B2, 0)
=MAX(8-10, 0)
=MAX(-2, 0)
=0
- Thanks dj, that worked & helped me a lot !
