Forum Discussion
How to get a cell with a formula to ignore another cell with a formula that shows up blank
Hello. I am using a Custom Formula in Column B, C, G and H, to format how the date will show on an excel Gantt Chart. My aim is for Column B to calculate 5 days prior to what is in Column C (example...
You can quantify any blank cell using "". I like to use an IFERROR in some formula cells. The make it equal a blank "" if an error in the cell. Then in your formula add a stipulation not equal to a blank or <>"".
- Thanks, I have tried that solution as well, I saw it online, but I think the Column B cell see it as text in the cell even thought the formulas in Column C renders them as empty.
That's just a guess. I wish I had a deeper understanding, uggh.
