- May 31, 2007
- Office Version
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)