Empty Errors

D

Don Cleve

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?
 
D

Don

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
 
F

Frank Kabel

Hi
not quite sure what you're trying to do but try
=IF(K5="","",IF(K5<0,68,69))
 
Top