I have a spreadsheet with total usage from my customers of data consumed in a month. Let's assume the cell value here is 429.68. In a separate sheet, I have values between 1 and 5000 in column A, and profitability margin in column B. I'm trying to write a formula that calculates which cell value in the second sheet the value falls within, and returns column B from the appropriate row (profit margin) for that particular usage.
I've tried a median IF statement but this doesn't work.
Any help would be appreciated.
I've tried a median IF statement but this doesn't work.
Any help would be appreciated.