Hi Guys,

I have the below issue,

Need to return a certain value for one cell for each of the below parameters:

If A1<80 Value to be returned in B1 is 0
If 80< A1 < 85 Value to be returned in B1 is 10
If 85< A1 < 90 Value to be returned in B1 is 20
If 90< A1 < 95 Value to be returned in B1 is 30
If 95< A1 < 100 Value to be returned in B1 is 40
If A1>100 Value to be returned in B1 is 50

Is it possible to do so ?