ChatterBank2 mins ago
Excel formula question
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....
Answers
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.