Get instant live expert help on I need help with excel if cell contains number
“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 a formula that states if Cell C contains 0 then Cell D = 0 but if Cell C contains any number greater than 0 then Cell D will equal the sum of Cells A and B
Solved by V. S. in 12 mins
I want to have Cell B6 Increase in number from cell B5 by one If Cell E6 contains any text. Can you assist please
Solved by G. L. in 12 mins
I need a formula that leaves the cell blank if a another cell is blank, but if it contains a number, I need to use an If formula to say if the number is higher than 5, "No", if 5 or lower "Yes". When the other cell is blank, it always says "No" and I can't get it to stay blank. The other cell also contains a formula =IF(G9="", " ",NETWORKDAYS(E9,G9)) which gives the number of business days between two dates, if G9 contains a date, but stays blank if G9 is blank. This works, but I can't do the same and combine it with the IF formula for the above.
Solved by A. F. in 25 mins
Cell E4 contains formula. I would like to highlight it (Cell E4) if it's overridden manually in Excel 2007.
Solved by V. S. in 30 mins
I NEED A GOOGLE SHEET FORMULA TO USE AN IF FUNCTION FOR EXAMPLE IF A CELL CONTAIN S ANY TEXT AT ALL THEN ANOTHER CELL POPULATES A NUMBER AND IF THE NEXT CELL IN THE SEQUENCE CONTAINS ANY TEXT AT ALL IT WILL THE SAME NUMBER AGAIN IF ANY CELL IS BLANK IT ENTERS NOTHING AND JUST LEAVES THE OTHER CELL BLANK
Solved by O. C. in 11 mins