Empty Errors
Hi
not quite sure what you're trying to do but try
=IF(K5="","",IF(K5<0,68,69))
--
Regards
Frank Kabel
Frankfurt, Germany
"Don" schrieb im Newsbeitrag
...
Yes but there is a problem with
=IF(K5<0,68,69)
which I use as a formula. Is it possible to use a double
If like IIF for this one?
Thanks again
-----Original Message-----
Hi
may be use something like
=IF(A1="","",your_formula)
--
Regards
Frank Kabel
Frankfurt, Germany
"Don Cleve" schrieb
im
Newsbeitrag ...
Is it possible to supress the error sign created when a
field is left empty or the date returning as 1900 and
display a field as empty but keep the formula until data
is present?
.
|