If function
Isn't that just saying =IF(H3=40,"Passed","Failed") ?
I don't think the AND is doing anything there?
--
David Biddulph
"Suleman Peerzade" wrote in
message ...
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
|