ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   if formulas (https://www.excelbanter.com/excel-discussion-misc-queries/199832-if-formulas.html)

a3rdcharm

if formulas
 
I'm trying to create a formula to do the following. Can someone help me put
this in the correct format?

If E8=X, then G8=(g4*m8)
and if E8 is blank, leave blank

I tried to post this before and I didn't see it post, so I'm sorry if it
appears twice.


Mike H

if formulas
 
What was wrong with the answers in your other thread?

"a3rdcharm" wrote:

I'm trying to create a formula to do the following. Can someone help me put
this in the correct format?

If E8=X, then G8=(g4*m8)
and if E8 is blank, leave blank

I tried to post this before and I didn't see it post, so I'm sorry if it
appears twice.


Sheeloo

if formulas
 
Enter the following in cell G8;
=IF(E8="X",G4*M8,"")

I am assuming G4 and M8 contain values to be multiplied and put in G8 if E8
contains X.

Let me know if this is what you wanted.

"a3rdcharm" wrote:

I'm trying to create a formula to do the following. Can someone help me put
this in the correct format?

If E8=X, then G8=(g4*m8)
and if E8 is blank, leave blank

I tried to post this before and I didn't see it post, so I'm sorry if it
appears twice.



All times are GMT +1. The time now is 04:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com