=IF(E8="X",G4*M8,IF(E8="","","whatever other answer you want")
--
David Biddulph

"a3rdcharm" wrote in message
...
Good question. I didn't think of that. Do you know how should I adjust
the
formula to address that situation?

"Gord Dibben" wrote:

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