Check out the ISNA() function, which will return a boolean result. You can
wrap this with something like: If(ISNA(...),"",...)

"belvy123" wrote:

Hi All

I am using the following formula

=IF(K49=0,MIN(K4:K38),LOOKUP(MAX(J4:J38),K4:K38))

with this formula if K49 is not equal to 0 and there is no value in J4:J48
and K4:K48
It returns a #NA .
For the most part this is not a functional problem but more of an asthetic
issue.
What can I add to this formula to get it to return a Blank cell if there is
no value in
J4:J48 and K4:K48.
This will tidy up my sheet and make it look much nicer

Thanks

Dan N

crunchnin numbers