Get instant live expert help on I need help with excel if error then blank
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need to write if S is blank then T but if not blank then S
Solved by V. U. in 15 mins
How do I state a formula in Excel that posits if (cell location) = blank then insert blank else do formula?
Solved by V. Q. in 21 mins
I NEED A IF ERROR VLOOK UP FORMULA THAT WILL PUT IN INFO ONLY IF A SPECIFIC VALE IS PRESENT. IF IT IS NOT AN EXACT MATCH THEN I NEED IT TO BE BLANK
Solved by I. E. in 13 mins
NEED A FORMULA TO SHOW THE FOLLOWING: IF (Q3) IS AFTER TODAY & (R3) IS BLANK,THEN "BEHIND SCHEDULE". IF (R3) IS POPULATED THEN "COMPLETE". IF (Q3) IS <TODAY THEN "ON TRACK", IF Q3 & R3 ARE BLANK THEN "ON TRACK"
Solved by E. U. in 15 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