I'm not quite sure what would make A1 equate to #NA, but try this:
=IF(A1=TRUE,"The Maximum Amount",IF(A1=FALSE,"The Median
Amount",IF(ISNA(A1),"The Minimum Amount")))

OR

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

Does that help?
Ron


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