Excel formula question

Lillabet | 19:12 Fri 29th Dec 2006 | Computers

2 Answers

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....

PC to LCD connection

dot matrix

Answers

1 to 2 of 2

Best Answer

No best answer has yet been selected by Lillabet. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

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

Question Author

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

1 to 2 of 2

Do you know the answer?