You can use the "0" string * 1 in another formula.

I appreciate you trying to set me straight, but please pay more attention to
your own posts. Your first attempt at the formula errors out, and your
correction of my formula, "You should have double quotes around your zero",
also errors.



"Joel" wrote:

You would get wrong results if you tried to used the results from your
formula in any arithmetic operation.

"Alan" wrote:

You are correct, at least my formula doesn't error.

"Joel" wrote:

Alan: You should have double quotes around your zero. It is a number not a
string.

"Alan" wrote:

=IF(ISNA(LOOKUP(9.99999999999999E+307,L7:L516)),"0 ",LOOKUP(9.99999999999999E+307,L7:L516))

Alan


"gwbdirect" wrote:

I am using this formula to get the last value in the column
=LOOKUP(9.99999999999999E+307,L7:L516)
The problem is when it has no value instead of 0 it gives me #n/a.
This is a problem because I have different sheets that have values and I
want to add them up for a total and n/a wont allow me to get a total. Is
there a solution or another formula that would give me a 0 instead of n/a
thanks