Finding the answer to a formula
Good morning,
I am having a lot of trouble with the formulas in a spreadsheet and can't quite figure out how to word what it is that I need. Hopefully this will at least come close enough to get a little help. =/ =MIN (b4*12-25%,b4*12-500) + MIN(c4*12-25%,c4*12-500) fills in the cell with the correct answer, but it's not quite the answer I need. Let me illustrate: The first part of the formula is to take b4 times 12 minus 25% --if this amount is less than or equal to 500 then use the total. If it is more than 500 then 500 should be used. (b4*12-25%) 234.25 * 12 = 2811 - 25% = 702.75 Since this amount is more than 500, 500 should be used instead. ~~this is actually the amount that I want to show in the cell, the amount saved~~ 2811 - 500 = 2311.00 ~~this is the answer that is showing up in the cell, which is not quite what I need. ~~ The formula seems to be going one step farther than I need it to go, but it's doing exactly what the formula tells it to do. I can't figure out how to tell the formula to give me the saved amount. Help? I did ask this question yesterday, but my question was more confusing than the formula I'm trying to get. I hope this one clears up what I need a little better. Thank you! |
All times are GMT +1. The time now is 06:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com