sheet help

[Liam Keefe]

hi i am creating a ebay profit loss worksheet for my friends i need to have
cell 'g6' to have if cell 'c5' falls into the catogries below. thanks for
the help if you can.

a.. 5.25% of the amount of the high bid or successful Buy It Now price up
to £29.99
-Plus-
b.. 3.25% of that part of the high bid or successful Buy It Now price from
£30.00 up to £599.99
-Plus-
c.. 1.75% of the remaining amount of current high bid or successful Buy It
Now price that is greater than £600.00

 

[JE McGimpsey]

See

http://www.mcgimpsey.com/excel/variablerate.html

One option could be something like

=SUMPRODUCT(--(C5>={0;30;600}),(C5-{0;30;600}),{0.0525;-0.02;-0.015})