=IF(COUNTBLANK(D2:F2)<3,MAX(D2:F2),"")

Note that there is a "less than" operator symbol just before the "3" in the
revised formula above. From where you're reading this (Excelbanter.com),
unfortunately such operator symbols [ less than, greater than ] won't appear
at all. So you've to be aware of this and insert the missing symbol(s)
manually ...
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--