| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
if formulas
In G8
=IF(E8="X",G4*M8,"") will take care of the two conditions in your example. What if E8 is not blank but also is not "X"? Gord Dibben MS Excel MVP On Fri, 22 Aug 2008 06:57:01 -0700, a3rdcharm wrote: I'm trying to create a formula that does the following. Can you help me put it in the right format? if E8=X, then G8=G4*m8 and if E* is blank, leave blank |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
| automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
| Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
| formulas for changing formulas? | Excel Discussion (Misc queries) | |||
Threaded Mode
