Hi, this may be very obvious however I have spent the last 30 minutes trying to figure it out with no luck.

In Cell D4, this will have a manually input figure of any where between 0%-200%

I'm trying to make Cell E4 formulate based on the assumptions below.

Less then 98% = 0
Between 98%-100% = 48
Between 100%-110% = 60
Over 110% = 72

Can anyone assist with the formula, I just cannot get this to work?

Appreciate any assistance!