Hi Everyone I'm trying to know the formula to get make the rating say fail,pass,or credit as i have had a mess around with the if formula to no avail ill post the file as I,ve been at it for over 2 hours I'm a beginner and I don't know where else to turn
I'm suppose to say if any of the 3 marks are under 60 its a fail,all over 60 is a pass and all over 80 is a credit,Its task 2 in the attachment
I've tried =IF(B2>=60,AND(C2>=60,AND(D2>=60,"PASS","FAIL",)OR (B2>=80,AND(C2>=80,AND(D2>=80,"CREDIT") to no avail
Attachment below any help is much appreciated
Task 2
Bookmarks