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

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

Hi

try

=if(anothercell=x,100,0)

note that the "=x" could be <,,=,etc

does this helps?
regards from Brazil - going to the 6th.
Marcelo

"changetires" escreveu:


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

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

if cell that has true/false in it is A1, then put this formula into the
cell that needs to be 0/100.

=IF(A1=TRUE,100,IF(A1=FALSE,0,""))


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

=(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

Thanks for the quick help. Works like a champ. Used Kevin's formula.

Thanks again

Ed


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

Love it Bob, lateral thinking at it's best!

Regards
Martin