Mar 03 2017
02:48 PM
- last edited on
Jul 25 2018
09:27 AM
by
TechCommunityAP
Mar 03 2017
02:48 PM
- last edited on
Jul 25 2018
09:27 AM
by
TechCommunityAP
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
Mar 03 2017 03:15 PM
Hello Chris
=IF(E7="","",F6+E7)
Mar 03 2017 03:30 PM
Thank you
It still returns the result of the formula. I'd the cell to remain blank until an entry is intered in E7.
Mar 03 2017 03:32 PM
Oh thank you. I figured it out. I had a space between the quoatation marks.
It works!
Thank you!
Mar 04 2017 07:49 AM
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.