I need to charge a customer a fee based on a fee schedule:
$0 to $125,000 @ 1.75% =
$125,001 to $250,000 @ 1.45% =
$250,001 to $500,000 @ 1.35% =
$500,001 to $1,000,000 @ 1.15% =
$1,000,001 to $3,000,000 @ 1% =
Total Fee Charged =
Each line above would be a row, so that the cell would show how much was charged at each breakpoint.
I know that there is a formula to figure this out, but I'm apparently not of the mental capability to do it!!
As Clint Eastwood said, "A man's gotta know his limitations"
Thanking you in advance,
-Sorbi
$0 to $125,000 @ 1.75% =
$125,001 to $250,000 @ 1.45% =
$250,001 to $500,000 @ 1.35% =
$500,001 to $1,000,000 @ 1.15% =
$1,000,001 to $3,000,000 @ 1% =
Total Fee Charged =
Each line above would be a row, so that the cell would show how much was charged at each breakpoint.
I know that there is a formula to figure this out, but I'm apparently not of the mental capability to do it!!
As Clint Eastwood said, "A man's gotta know his limitations"
Thanking you in advance,
-Sorbi