Thread: exam marks into grades
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default exam marks into grades
Will this help. With marks in A1
=IF(A1<40,"FAIL",LOOKUP(A1,{40,60,70,80},{"D","C", "B","A"}))
--
If this post helps click Yes
---------------
Jacob Skaria


"Sharon R" wrote:

How do I convert exam marks into grades using spcified grade boundaries?
Reply With QuoteReply With Quote