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

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

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

Perfect. Thanks.

"Mike H" wrote:

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

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

=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

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

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=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

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.

"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

=IF(A220,A22*A23+45,IF(A22=0,"","input negative and output undefined")
--
David Biddulph

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

"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

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

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