Forum Discussion
Writing a formula to return a blank if no data is in an adjacent cell
I've forgoten how to how to write a simple formula that will keep the cell blank if there isn't any data in an adjacent otherwise it should do the calculation.
This is how I wrote it.
=IF((E7=" "," "),(F6+E7))
Thank you
Dear Chris,
You can also replace this part: E7="" , by this one: ISBLANK(E7)
This will help you to restrict the applying of the formula more then ever.The applying with this replacement will stop only for the completely blank cells.
please i also need help. above is my table cell a3, b3 and c3 which are blank. i want d3 to be blank too if no data is entered in either a3, b3 and c3. this is my formula used for CELL d3:=(SUM(D2,A3))-(SUM(B3,C3))
Hello Chris
=IF(E7="","",F6+E7)
Thank you
It still returns the result of the formula. I'd the cell to remain blank until an entry is intered in E7.
Oh thank you. I figured it out. I had a space between the quoatation marks.
It works!
Thank you!
