Need help with a simple formula

C

changetires

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
 
K

Kevin B

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,""))
 
M

Marcelo

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:
 
G

gareth93

changetires said:
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
Click to expand...

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,""))
 
C

changetires

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

Thanks again

Ed
 
Top