Excel help

I need to create an excel formula where if there is no value in Column B then I want Column c to be blank as well, if Column B has a value then I need it to use a formula in Column C instead of leaving it blank.  Any ideas?


Would you like to answer or comment?

Sign up for a free account, or sign in (if you're already a member).
Answer this question

Topics:

  • # Posted 2 years ago
  • 2442 views
Share Send to a friend Watch Report
 

Best Answer

 
Mark50
22 answers
52 thumbs up

Try this:

In the first cell of your C column that has potential values in the B column (let's say that is row 12), use the formula

 =if(B12, $G$2-B12, "")

This says, "if B12 contains a value use the formula $G$2-B12 to calculate a value for the cell, other wise assign the value "" (null) to the cell."

Copy this formula down the C column.

Does that produce the desired result?

 
Posted 2 years ago ( permalink )
In reply to Deblee1035's answer
Rated as
Best Answer
0
4
  Report Abuse  

Helpful?

line
line
line


 

All Answers

Order by
 
machambi
1 answer
2 thumbs up

copy the below into the formula bar for C.  

 

=(IF(B1,B1,""))

 

 
Posted 2 years ago ( permalink )
In reply to Deblee1035's question
Rated as
#2 out of 6
0
2
  Report Abuse  

Helpful?

line
line
line



 

I think I'm on the right track but if there IS a value in Column B then I need Column C to use the following formula:  =$G$2-B12  instead of leaving the C cell blank. 

Posted 2 years ago ( permalink )
In reply to machambi's answer
Rated as
#3 out of 6
0
0
  Report Abuse  

Helpful?

line
line
line



 

That's it!!  Thank you so much!! 

Posted 2 years ago ( permalink )
In reply to Mark50's answer
Rated as
#4 out of 6
0
0
  Report Abuse  

Helpful?

line
line
line



 

All set -thanks!!

Posted 2 years ago ( permalink )
Rated as
#5 out of 6
0
0
  Report Abuse  

Helpful?

line
line
line



 

Using VBA in a macro you can use the following

 Cells(1, 2).Value = "" 

Your end arrow test will not stop on this cell. 

 
Posted 2 years ago ( permalink )
In reply to
Rated as
#6 out of 6
0
0
  Report Abuse  

Helpful?

line
line
line



Sign in to participate

Got an answer for Deblee1035? Would you like to comment on the posted answers, or vote for the one which you think is the best?

Sign up for a free account, or sign in (if you're already a member).

Explore Related Questions

Other people asked questions on similar topics, check out the answers they received:


Is mac really better than a pc?

is mac really better than a pc?
Submitted by eyal_b 11 months ago
  • 11 answers
  • viewed 1260 times