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

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