# Get instant live expert help on if cell is blank then

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

I need a formula that when cell A63=1 then cell A50=1 or if A63 is blank then cell A50 should be blank
Solved by G. J. in 12 mins
HI, I am adding a1+b1 together but sometimes one or the other cell is blank and the formula doesn't work. so this is what I was trying..... if cell b1 is blank then return cell a1 value,or if cell a1 is blank then return cell b1 value, otherwise sum a1+b1
Solved by A. Y. in 12 mins
If a cell is blank, then enter data from another column
Solved by S. D. in 23 mins
IF SUM OF RANGE IS MORE THAN ZERO,THEN SUM IF THE RANGE IS BLANK THEN BLANK IF THE RANGE HAS ONLY ZERO,THEN ZERO HOW SHALL I COMBINE THE ABOVE THREE IN A SINGLE CELL??
Solved by M. D. in 24 mins
I am having an issue with "IF". I am trying to write a formula: e.g. IF Cell C16 is blank then, i need text "No comparable value" - if cell D16 is blank then I need text "No comparable value" if C16 is greater than D16 by 20 or more then blank cell (same the other way around) - if C16 is greater than D16 by 19 or less then I need text to display "Small sample, further review needed"
Solved by Z. C. in 19 mins