Forum Discussion
Solved
Excel IF Formula
Hi, I've searched google and the forums for the answer to my query to no avail. What I am trying to do is calculate a % number based on a tiered structure, as follows: Cell B1 will be a percenta...
ash_m200 Actually, similar questions have come up here twice the past week, though applied in different contexts.
https://techcommunity.microsoft.com/t5/excel/band-billing/m-p/1632141#M73901
Attached is the same type of solution that I provided then. I've adapted it to your specific situation. I trust you can apply the method demonstrated into your own file. If not, come back here.
I believe this is best done by looking up the rate from a table.
= amount * LOOKUP(amount, rates)