Graywolf80
New Member
- Joined
- May 11, 2010
- Messages
- 20
Im trying to setup my key for lookup parameters. Is there a way to set a range for it look for in one cell?
Example, If a product ends up being 89.9% in one cell, and I am asking another cell to display its end result with a word.
In my legend/key can I place the range of 80%-90% in the 1 column and Excellent in the 2nd column.
How can I make this work? Or do I have to use each percentage in a seperate cell with the description next to each?
Thanks in advance, and hope this wasnt too confusing.
Example, If a product ends up being 89.9% in one cell, and I am asking another cell to display its end result with a word.
In my legend/key can I place the range of 80%-90% in the 1 column and Excellent in the 2nd column.
How can I make this work? Or do I have to use each percentage in a seperate cell with the description next to each?
Thanks in advance, and hope this wasnt too confusing.
