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