I need a cell to display either 100 or 0 depending on if another cell
has pass or fail typed into it. Can anyone help with this one?

Thanks,

Ed


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=551825