Hi!

Do the test for #N/A first:

=IF(ISNA(A1),"The Minimum Amount",IF(A1=TRUE,"The Maximum
Amount",IF(A1=FALSE,"The Median Amount")))

Biff

"mick2" wrote in
message ...

Thanks Ron,
I tried both suggestions, but the problem is stil there.
Mick2


--
mick2
------------------------------------------------------------------------
mick2's Profile:
http://www.excelforum.com/member.php...o&userid=24143
View this thread: http://www.excelforum.com/showthread...hreadid=488434