Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! Last edited by txheart : April 18th 08 at 03:16 PM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array formula correct but end up with 0 for answer | Excel Discussion (Misc queries) | |||
Won't give correct answer | Excel Worksheet Functions | |||
Finding Correct Answer | Excel Worksheet Functions | |||
VLOOKUP not returning correct answer | Excel Worksheet Functions | |||
when i input (=r3*s3) the answer is not correct? | Excel Worksheet Functions |