hi guys does anyone out there know why this formula does not work:
=IF(H29=>70,"1st",IF(H29>=60AND>=69,"2:1",IF(H29>=50AND>=59,"2:2",IF(H29>=40AND<=49,"3rd"))))
The formula is to work out the class of an honours degree for a certain student.
thanks guys.![]()
Bookmarks