if formulas

  • Thread starter Thread starter a3rdcharm
  • Start date Start date
A

a3rdcharm

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if formulas 6
if the date 1
Complex Autofill does not follow formula 4
Figuring 24 Hours Per Day 5
IF statement with nested SUMPRODUCT? 3
Sum not adding cells. 3
Excel Version Problem 2
Nesting Formula 4

Back
Top