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

--
Thanks
Suleman Peerzade


"Sullu" wrote:

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