exel help

[zed]

machan how to say in exel to

if lesser than 50 display "fail"
if > than 50 "pass"

 

[TΞΞNSTAR™]

Self Study ..

http://www.timeatlas.com/mos/5_Minute_Tips/General/Excel_Basics_and_the_IF_Function/

 

[x-pert]

=IF(cell>=50,"PASS","FAIL")

Which means:

within brackets - 1st condition, the value if the condition is true, the value if condition is false.

 

[xcorect]

=if(a<50,"Fail","Pass")

a should be a cell address

 

[zed]

Self Study ..

http://www.timeatlas.com/mos/5_Minute_Tips/General/Excel_Basics_and_the_IF_Function/

thankxxxx

=IF(cell>=50,"PASS","FAIL")

Which means:

within brackets - 1st condition, the value if the condition is true, the value if condition is false.

thankzzzz

=if(a<50,"Fail","Pass")

a should be a cell address

thxxxaa

 

[RuwinRTY]