Forum Discussion
Excel IF Formula
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.
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.
Thank you - that did work, apologies for not finding the other posts
ash_m200 No apologies needed. Not easy to find these threads where one calls it "banded billing" and another "Help with a formula". You yourself called it "Excel IF Formula". And all of you were looking for some kind of tiered fee calculation. Glad I could help.
Why not
= SUMIFS(RateDiff, Lower, "<="&Qty)
You appear to be catering for very old versions of Excel.
