| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formulas using two cells
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
