If the #N/A's are the result of Vlookups then MAX(............) will reutrn
#N/A.

Biff

"pinmaster" wrote
in message ...

Maybe,

assuming only 1 number in the 3 cells.
=MAX(B1:D1)

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile:
http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=501901