I have a cell where I want to return a number based on the math of 2 cells above. In addition, depending on the result of the math, I want it to return a maximum and a minumum number. Using the attached spreadsheet, cell O24 is where the result should go. Here's the logic:
• If O13 = O20 then return $125,000
• If O13 > O20 then return ($125,000 + ((O13 – O20)* .15))) but if the result is greater than $156,250 continue to return $156,250 (this is the maximum)
• If O13 < O20 thePool 2013.xlsxn return ((O13/O20) * $125,000) but if the result is less than $112,500 then return zero ($112,500 is the minimum).
For some reason, I think I should be able to write this myself but I'm drawing a blank. I'll probably have an AH-HA moment as soon as I see some answers!
Thanks!
Peg
Bookmarks