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.
See the attached demo.
is there a way to enter the formula in each column, so i can add a "total" at the end?
Yes, if you wish:
- I appreciate your help greatly. the key is items in row 1 as "next" for each column?
Shouldn't e5 be 18,750?
Shouldn't f5 be 17,500?
Shouldn't g5 be .069% of anything over 7.5 million?0.075% of $2,500,000 is $1,875 and not $18,750.
0.070% of $2,500,000 is $1,750 and not $17,500.
The remaining amount over $7,500,000 is $500,000.
0.069% of $500,000 is $345.
Perhaps the percentages should have been 0.75%, 0.70% and 0.69%? The jump from 1.00% to 0.075% is very large...