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(A220,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.
--
David Biddulph

"susieh" wrote in message
...
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.

"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