Forum Discussion
Solved
need help on conditional if formulas
Trying to insert formulas for spreadsheet below RATE 1st $100,000 RATE next $400,000 RATE next $2,000,000 RATE next $2,500,000 RATE next $2,500,000 RATE over $7,500,000 RATE 2.500%...
See the attached version.
it all seems to work, except if A5 is 0, i get negative numbers in all columns, how can i fix that?
See the attached version.
- Hans, thanks much, you have solved my problem(s).