Hi Gurus,
Can somebody help to put the IF nesting formula together, please?
I need to put the following figures in IF NESTING:
Income Offset
up to $37,000 $255
$37,001 to $48,000 $255 plus 7.5 cents for each dollar over $37,000
$48,001 to $90,000 $1,080
$90,001 to $126,000 $1,080 less 3 cents for each dollar over $90,000
I have attached the spreadsheet and a picture which shows the rate.
Thank you.
Bookmarks