This formula might do the trick for you. The formula assumes the pass or
fail entry is in cell A1

=IF(A1="Pass",100,IF(A1="Fail",0,""))
--
Kevin Backmann


"changetires" wrote:


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