if formulas

[a3rdcharm]

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

 

[Mike H]

Try this in G8

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

Mike

 

[Gord Dibben]

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

 

[a3rdcharm]

Perfect. Thanks.

Try this in G8

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

Mike

 

[a3rdcharm]

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

 

[susieh]

For some reason I cannot post a new thread, so I aam adding to this one.

Does anyone know how to create a formula for this?

I want to get a value in A22 and if that value is greater than 0 (even if it
is less than 1), then multiply A22 and A23 and add 45 to the total, if the
value in A22 is 0, then I want the cell to be empty.

 

[susieh]

Thank you, David.

I tried that and I keep getting the #VALUE! message in that cell. In A22, I
have a calulation from above that is =A14-INT(A14). Basically, I want to
take any partial from line 14, put it on line 22 and then multiply by line 23
and put the total in this cell. Right now, line 22 is 0, so I want the cell
to be blank, but it has #VALUE! instead.