| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formulas using two cells
Your first formula doesn't make much sense as there is only a single argument meaning it is the same as 220-F2. Given that, try putting this in G2 (and copying down as needed)...
=IF(E2="H",220-F2,MAX(MIN(210-E2,60),0)) -- Rick (MVP - Excel) "Mark" wrote in message ... I have a formula in column G =MAX(MIN(220-F2)) that I want to set only if the text in column E is set to the value of "H". If the value in column E is < H then I want the formula in column G to be =MAX(MIN(210-E2,60),0). How do I have this conditional formula in the same cell? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| Formulas in Cells | Excel Discussion (Misc queries) | |||
| copy formulas from horizontal cells into vertical cells. | Excel Programming | |||
| Show cells with formulas without permanently changing the cells | Excel Programming | |||
| AdvancedFilter on cells with formulas, returning values and not formulas | Excel Programming | |||
Threaded Mode
