I am trying to figure out the best why to create an 'IF' statement to see if a data price point falls under the appropriate price range based off the percentage
So here is the table i am going off of
Percentage Range Price Range
>90% $68.00 - $70.00
80-89% $69.00 - $71.00
70-79% $70.00 - $72.00
60-69% $71.00 - $73.00
<60% $75.00
So, >90% needs a price in the range of $68-$70 to be a true statement
How do i create a formula to figure this out?
For Example:
This is a True Statement
Let's call cell A2) 60%
Let's call cell B2) $71.00
This is a False Statement
Let's call cell A2) 60%
Let's call cell B2) $69.00
Does this make sense? Thanks in advance!
Bookmarks