Help with #Value!

Question

In the picture below I'm trying to compute a value for cells E5 and E6. Basically, I'm blanking out how address an error message (#VALUE!) for cell E5. Cell C5 is actuall a formula and that why in reality it delivers the error message not $0.00. Cell G5 is a copy of the formula in cell E5. Cell G6 is a copy of the formula in cell E6. Cell E5 should be blank, while cell E6 should be $170,597.30.

Answer 1

K17 cannot be blank if that formula is returning an error. Based on your earlier post, I'd suspect your formula in those cells is returning " " and not "".

There are many ways to deal with this sort of situation. For example, you can use IFERROR:

=IFERROR(N17*45360*$C$13,"")

which will handle the situation where either N17 or C13 do not have number values in them.

If you know C13 will always have a number in, you could simply test if N17 has a number:

=IF(ISNUMBER(N17),N17*45360*$C$13,"")

You could also amend the formulas in K:N to return 0 rather than "".

Answer 2

I'm sorry but I'm still having problems.

See below

Why am I getting the error message indicator (#VALUE!) for the P16....... column?

What is the correct formula for handling blank cells, whe ntheir isn't and data in the (K-O) rows, inreference

to the P16............. Column. The formula is correct. It dealing with no data. Each or the cell in the range (K16:O18) are populated by formulas. Actual it really (K16:O1222).

Thanks

Answer 3

No, not exactly:

=IF($C$6="","",($C6*43560)*$B$2)

Answer 4

Is this what your talking about?

=IF($C$6=""not=" ",($C6*43560)*$B$2)

Thanks

Answer 5

To test for blank, you want to test for ="" not =" "