Jun 07 2021 01:01 PM
If balance is less than $200 then 5% of the balance
If balance is between $200-$1000 then total fee charged $10
$10.00 per month for the first $1,000.00 plus 5% percent for any amount in excess of $1,000.00
Jun 07 2021 01:06 PM
SolutionLet's say the balance is in cell B2. The formula for the fee is:
=IF(B2<=200, 5%*B2, 10+5%*MAX(B2-1000,0))
Jun 07 2021 01:08 PM
Jun 07 2021 01:20 PM
Jun 07 2021 01:06 PM
SolutionLet's say the balance is in cell B2. The formula for the fee is:
=IF(B2<=200, 5%*B2, 10+5%*MAX(B2-1000,0))