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% | 1.500% | 1.000% | 0.075% | 0.070% | 0.069% |
| $100,000 | $400,000 | $2,000,000 | $2,500,000 | $2,500,000 | ||
| CONTRACT AMOUNT | ||||||
| $8,000,000.00 | $2,500.00 |
See the attached version.
11 Replies
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:
- What's your goal with this spreadsheet?
- to calculate bond rates, for each column - need correct formula(s) to enter. Thanks
