Hello,
Assuming that you wish G5 to display no information if your other
conditions are not true you can try this.

=IF(G4="","",IF(G4=0,4,IF(G4=1,2,IF(G41,0))))

Regards,

SteveG


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=274153