Excel formula question

[Lillabet]

Hello, In excel I want to set up a formula that will do the following: Look at the value in a cell and see if it is for example under 10, between 10 and 20 or over 20. Depending on this I want the formula cell to then be completed with the words low,medium,high I know how to do a basic logical test formula using the =if formula but not how to include 3 variables. Help please....

[CheekyChops]

What you want is a nested IF statement. I did one, putting the values in cell A1, B1 etc and this formula in A2 worked:

=IF(A1>20,"HIGH",IF(A1>10,"MEDIUM",IF(A1>0,"LOW")))

Then I just dragged it down into B2, C2 etc

[Lillabet]

Thank you so much. I've been staring at it for ages. You are an absolute star!