Hello All,
On the attached, you will see I have 10 customers listed with a Gross List Price value and a discount value. On the second sheet ("parameters"), you will see that I have three measures that correspond to the discount level (Out of Bounds, Left fairway, and Right Fairway) and also a Gross List Price Value.
Here is what I am after-
I need to come up with a way to identify where these values would plot on a graph for each of my 10 customers. For instance, Applied Materials has a Gross List Price of 81M and a discount of 96%, if I switch over to my "parameters" worksheet, I would see that this customer would be plotted as "Out of Bounds" since the Gross List Price is over 10M and the discount is 96%. Is there a way to do this with a formula rather than the way I have been doing it manually?
Any and all help is greatly appreciated!
Thanks!
Andrew
Bookmarks