>
> So it would be as simple as...
>
# Of Transactions = 250
100 Transactions @ $60 = $6,000 x Billing Rate of .003 = $18 Fee
150 Transactions @ $40 = $6,000 x Billing Rate of .002 = $12 Fee
Total Fees = $30
--
# Of Transactions = 50
25 Transactions @ $60 = $1,500 x Billing Rate of .005
Hi,
Please provide sample data and expected output.
Regards,
Swapnil Suresh Palande
On Thu, May 4, 2017 at 8:21 PM, Spencer Patterson <
williamspencerpatter...@gmail.com> wrote:
> I need to solve a problem and I need help with the IF:THEN:ELSE
> calculation please.
>
>
> I need to create a spre
I need to solve a problem and I need help with the IF:THEN:ELSE calculation
please.
I need to create a spreadsheet where this is the model and calculate costs.
IF(TRANSACTION) IS MORE THAN $50, AND UNDER 100 TRANSACTIONS TOTAL, BILLING
RATE IS .005
IF(TRANSACTION) IS LESS THAN $50, AND UNDER