=(A1="Pass")*100

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"changetires"
wrote in message
...

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