How can I calculate a progressive fee?

I need to calculate a three-tier progressive fee in Excel.

X% for just the first $A
then Y% between $A and $B 
and Z% for greater than $B.

Just not sure how to translate this to Excel language.

Recent Questions...