If function

[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

 

[Suleman Peerzade]

try this,
=IF(AND(H3>=40,H3>=40),"Passed","Failed")

 

[Sullu]

Thanks a ton this is work as required

try this,
=IF(AND(H3>=40,H3>=40),"Passed","Failed")

 

[David Biddulph]

Isn't that just saying =IF(H3>=40,"Passed","Failed") ?
I don't think the AND is doing anything there?