If function

  • Thread starter Thread starter Sullu
  • Start date Start date
S

Sullu

Hi,

I have this table with me and want to use if function the requirement is if
a roll number has less than 40 marks it should be shown as failed in the next
column.
Any help


Roll No Maths Phy
1 90 30
2 67 70
3 56 50
4 45 47
5 23 78
 
Isn't that just saying =IF(H3>=40,"Passed","Failed") ?
I don't think the AND is doing anything there?
 
Back
Top