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?

 

[David Biddulph]

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

 

[David Biddulph]

Whoops! Forgot the closing parenthesis.
=IF(E8="X",G4*M8,IF(E8="","","whatever other answer you want"))

 

[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.

 

[David Biddulph]

=IF(A22>0,A22*A23+45,IF(A22=0,"","input negative and output undefined")

 

[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.

 

[David Biddulph]

You have replied to the original message on the thread, not to mine or even
to your own question. If you were trying to reply to a message of mine,
reply to that one and quote enough of it so that I and anyone else can see
the formula to which you are referring.

If I have guessed correctly what your talking about, and you are referring
to my reply of
=IF(A22>0,A22*A23+45,IF(A22=0,"","input negative and output undefined"))
[replacing the missing closing parenthesis which had got lost from my
reply], then my guess would be that you haven't actually got 0 in A22.
Try displaying some more decimal places in A22 to see what you've really
got. If you really had zero, the output of my formula would be an empty
string.
To get #VALUE! you've either got a string in A22, or a positive number in
A22 and a string in A23.