Hi all

I am trying to use if formula to satisfy 5 conditions, for example:
in column D i have all different percentages, but if the percentage is equal or greater than 4, then I want to return the value 5 to column E,
if it's equal or greater than 2 but smaller than 4, then column E should show up as 4,
if it's between -1 and 2, but smaller than 2, then column E should show up as 3,
if it's greater than -1 but smaller than -4, then column E should show up as 2,
if it's equal or greater than -4, then column E should show up as 1,

Any clue on how to satisfy these 5 conditions in 1 formula?

Much appreciated!

Harry