| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if formulas
I'm trying to create a formula to do the following. Can someone help me put
this in the correct format? If E8=X, then G8=(g4*m8) and if E8 is blank, leave blank I tried to post this before and I didn't see it post, so I'm sorry if it appears twice. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formulas
What was wrong with the answers in your other thread?
"a3rdcharm" wrote: I'm trying to create a formula to do the following. Can someone help me put this in the correct format? If E8=X, then G8=(g4*m8) and if E8 is blank, leave blank I tried to post this before and I didn't see it post, so I'm sorry if it appears twice. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formulas
Enter the following in cell G8;
=IF(E8="X",G4*M8,"") I am assuming G4 and M8 contain values to be multiplied and put in G8 if E8 contains X. Let me know if this is what you wanted. "a3rdcharm" wrote: I'm trying to create a formula to do the following. Can someone help me put this in the correct format? If E8=X, then G8=(g4*m8) and if E8 is blank, leave blank I tried to post this before and I didn't see it post, so I'm sorry if it appears twice. |
| Reply |
| 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) | |||
Hybrid Mode
