If Function to Calculate Shipping Charges

[Guest]

=IF(F7>101,"0.08*F7",IF(F7>76,"7.99",IF(F7>51,"6.99",IF(F7>26,"5.99","4.99"))))

Problem:

Item Cost Shipping Cost
0 - 25 $4.99
$26 - $50 $5.99
$51 - 75 $6.99
$76 - 100 $7.99

$101 8% of Item Cost

I've created the above formula to calculate shipping charges. All of the
fixed charges ($7.99, $6.99, $5.99 $4.99) work. The charges for F7 that are
calculated by a formula using F7 in the formula does not work when combined
with the other rates. This formula (F7>101,0.08*F&) works fine when not
combined with the other costs. Help!

 

[Guest]

Hi Dawn

You do not need the Quotation marks

=IF(F7>101,0.08*F7,IF(F7>76,7.99,IF(F7>51,6.99,IF(F7>26,5.99,4.99))))

Regards
Peter