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=" ...
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))