Saturday, 10 August 2013

Multiple conclusions(formulas) in one cell

Multiple conclusions(formulas) in one cell

Let's say I have a table with the values:
0
100
200
300
In the next coloumn I have data entry cell of 250. Underneath the 250 I
would like a formula that says:
If 250 is less than 100 but more than 0, "A"
If 250 is less than 200 but more than 100, "B"
If 250 is less than 300 but more than 200, "C"
Based on that formula, the cell below would automatically be "C"
How do I create that formula?

No comments:

Post a Comment