Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need to set a maximum amount on several input values in a formula.
=(MIN(1))+IF(E11C11*5,H11-1)+IF(E11<C11*5+1,E11-1+F15)+IF(C11*5=H11,H11+F15+G15-500) This formula suits my purpose until the value of C11 exceeds the value of E11/5 after C11 exceeds 100. The Maximum value for the target cell is 500 plus F15 plus G15 example: when C11=496 and E11=2483 and F15=2 and G15=8 the result equals 510 (this works when C11= any whole number from 101 up unless it is greater than E11/5) When the value of C11= 497 or greater and the value of E11, F15 and G15 remain constant the result is 2945 which is the sum of E11, F15 x 2 and G15. Once the value of E11 exceeds 5 x C11 the result returns to the desired result How can I elimiate this occurrance when C11 exceeds E11/5? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how should I setup workbook to acheive my desired results? | Excel Discussion (Misc queries) | |||
highlighting cells that have desired results | Excel Discussion (Misc queries) | |||
Returning the desired value if multiple values exist???? | Excel Worksheet Functions | |||
Results of conditional formatting not what desired. How do I corr | Excel Worksheet Functions | |||
Vlookup Returning Same Results on Each Row | Excel Discussion (Misc queries) |