Can anyone capture the following logic in a nested-IF statement so I can copy/paste straight into Excel?
£0.01 - £4.99 10% for the amount of the selling price up to £4.99
£5.00 - £9.99 10% of the initial £4.99 plus 8% of the remaining selling price balance
£10.00 - £49.99 10% of the initial £4.99 plus 8% of the initial £5.00 - £9.99 plus 6% of the remaining selling price balance
£50.00 - £499.99 10% of the initial £4.99 plus 8% of the initial £5.00 - £9.99 plus 6% of the initial £10.00 - £49.99 plus 4% of the remaining selling price balance
Over £500 10% of the initial £4.99 plus 8% of the initial £5.00 - £9.99 plus 6% of the initial £10.00 - £49.99 plus 4% of the initial £50.00 - £499.99 plus 2% of the remaining closing value balance
2006-09-04
04:31:03
·
6 answers
·
asked by
Anonymous
in
Science & Mathematics
➔ Mathematics
Using C9 to represent 'selling price'
2006-09-04
04:32:12 ·
update #1
i don't think any of you fully understand - I am a complete imbecile when it comes to formulas, and can't do it myself. Whilst all your suggestions are probably great, I wouldnt know where to start. I'm just trying to get excel to calculate fees around eBays new pricing:
http://pages.ebay.co.uk//sell/importantinfo/
2006-09-04
04:46:20 ·
update #2