Formula where value cannot be less than zero

[leopardhawk]

This formula works for me except that if 'oas recovery tax'!D5 is greater than a certain threshold, in this case 125650, then it is returning a negative amount. I am hoping that there is a modification to the formula that will ensure that it never returns a value less than 0 (zero).

=IF(D35>'oas recovery tax'!D5,D41-(0.15*(D35-'oas recovery tax'!D5)/12),D41)

 

[Rick Rothstein]

Re: Need help with formula where value cannot be less than zero

Maybe...

=MAX(0,IF(D35>'oas recovery tax'!D5,D41-(0.15*(D35-'oas recovery tax'!D5)/12),D41))

 

[leopardhawk]

Re: Need help with formula where value cannot be less than zero

Brilliant! Thanks you so much for your time and effort.