cells deleting by themselves

[rholdren]

I had a friend send me a file to fix and i haven't been able figure it out

the problem is if any of the data in

Column A Column B Column C Column D

Jane Smith

5/1/2017

6/17/2017

7/30/2017

<tbody>
</tbody>

The formula in Column D4 is =IF(ISBLANK($B4),"",B4 +90) 5/1/2017 is the data in B4 But if you delete the data in B4 the formula is D4 deletes itself
The file sent to me has 30 rows of data all of them do the same thing There are also formulas that are similar in columns that work off the data in in B and they also disappear at the same time.

Any help would be greatly appreciated

Thanks

 

[rholdren]

Never mind. I didn't understand what her issue was. The formula should disappear. It is only invisible when it doesn't have something to calculate. It's still there. Sorry for the inconvenience

 

[mikerickson]

The formula should not disapear, it should still be in the Edit box when you select the cell.
The value that it returns should be "" and the cell be blank.