Discussion Locked

Excel Question

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Can anyone help me find a way to handle a #VALUE error. I'm adding fields from a worksheet and placing them on a new worksheet. It's tracking by month, and when the fields are blank (prior to entering the data) the total sheet shows #VALUE. How can I get it to show blanks rather than the error

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 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.

This discussion is closed to new replies.