I have attached a screenshot of my worksheet.
I have a range of prices in Column A. Column B cells need to display the percentage of the column A value, where the percentage is based on which price range (eg D2:E2) the Column A value lies within.
eg.
A2 = 150
B2 = 22.5 (because 150 lies within the range of 0-1499 and is assigned a percentage value of 15%. 22.5 is 15% of 150)
D2 = 0
E2 = 1499
F2 = 15
Hope someone can tell me what formula I need to generate the Column B values, because unfortunately I have no idea.
Thanks
Bookmarks