Try this in G8

=IF(E8="X",G4*M8,"")

Mike

"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