Hi, I am having trouble with a calculation on a spreadsheet and not having much luck in figuring it out.
Problem
A6 result is $25,000 (total order value)
I need B6 to calculate a charge rate.
The charge rate is -
Orders <$15,000=$25
Orders >$25,000=$35
Orders >$50,000=$50
I would really appreciate assistance with this one.
Thank you
Debbie
Problem
A6 result is $25,000 (total order value)
I need B6 to calculate a charge rate.
The charge rate is -
Orders <$15,000=$25
Orders >$25,000=$35
Orders >$50,000=$50
I would really appreciate assistance with this one.
Thank you
Debbie