Logical , functions , on ( IF , AND , OR)

Originally Posted by The Learner

55 - 65 ( 5 points ) , 66 - 76 ( 10 points ) 77 -87 ( 15 points ) 88 - 98 ( 20 points )

Base on your request, it is still short of some information.

For score below 55, will it be 0 points or 5 points? For score above of 98, will it be 20 points or higher?

Below is the formula I used.

Formula:

=IF($B1-54<=0,0,ROUNDUP(($B1-54)/11,0)*5)

Attached is your file.