I am looking for help figuring out a formula that will calculate the following:
<tbody>
Range
Bonus (per million)
$7 Million - $16 Million
$5,000
$17 Million - $27 Million
$2,500
$28 Million +
$1,000
</tbody>
Thank you!
I know I've done this a hundred times, but it must be late.
Need formula to produce the required monthly payment to reach $16,000.
15 yrs x 12 payments
Earning 8.2% annually
Thanks!!
Mike
Hi,
I am looking for some help. I am looking to have PMI automatically generate in the red PMI location if the loan amount is less than 20%
I think I would use an If function for this but I have not used excel in this capacity for 10 years and I am a little rusty.
In theroy what I am...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.