J
Jan Kronsell
I have cell (D1) with this formula:
=IF(ISNA(VLOOKUP(C1,Navne,2,FALSE)),"";VLOOKUP(C1,Navne,2,FALSE))
If C1 is N/A, it returns an empty string. The problem is, you cant multiply
an empty string.
So my next formula =D1*10 it gives me a VALUE error. I would like to give me
a 0 in stead. I know I can change ti formula to insert a zero instead of the
"", but is there other way you can do it? I would like to avouid the
zero-value in D1.
I know I can make conditonal formatting of D1, or suppress the showing of
zeros.
Jan
=IF(ISNA(VLOOKUP(C1,Navne,2,FALSE)),"";VLOOKUP(C1,Navne,2,FALSE))
If C1 is N/A, it returns an empty string. The problem is, you cant multiply
an empty string.
So my next formula =D1*10 it gives me a VALUE error. I would like to give me
a 0 in stead. I know I can change ti formula to insert a zero instead of the
"", but is there other way you can do it? I would like to avouid the
zero-value in D1.
I know I can make conditonal formatting of D1, or suppress the showing of
zeros.
Jan