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 Hi Andrew,
You can achieve this using a simple if statement, You can even incorporate the formula in if condition to get the result in same column.
=IF(B4>=0,B4,0)
Hi Vinod2406, that's brilliant. I mucked around trying something like that but you obviously need to know the exact structure/make up of the statement.
Thanks for your help !
Thanks for your help !