5 replies
by brian
Here is a simple formula that may fix your problem. You can see how this works if you paste this into A2 on a blank sheet. Put a value in A1 and you will get formula as the result. Press delete to dlete all data from A1 and you get nothing.
=IF(A1="",,"FORMULA")
Replace FORMULA with the actual formula that you have been using in the cell.
This is saying look at A1, if it has nothing ("") in it enter nothing. If it doesn't have nothing enter formula.
Here is an example of how this works.
Enter this formula in A2
=IF(A1="",,B1+C1)
Enter 1 in A1, B1, and C1.
A2 will display 2 (1+1)
by lisaj
by dklippert
Number one is correct. You could also use
=If(ISBLANK(A1),,"Formula")
For your own information, look up ISERROR.
With an empty cell selected go to Insert>Function. Choose Information on the left side and then highlight ISERROR. Click the question mark in the lower right corner and then, if the assistant asks, choose Help with this feature and then Help on selected function.
by lisaj
by lisaj
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending