Excel calculation for eBay

  Neill 20:40 17 Nov 2004
Locked

Help please on an Excel formula for eBay listings. I want to calculate the charges made by eBay. The first £29.99 of a sale is charged at 5.25% of the amount and anything £30 or over has a charge of 3.25%. So if an amount is £50, I need to find out 5.25% of £29.99 then 3.25% of £20.01. I have a clumsy formula that calculates two amounts in separate cells: how much below £30*5.25% and how much over £30*3.25%. Then from those two calculations, it finally adds them together. I'd tried a nested IF but it didn't work. Any ideas? Thanks. Neill

  VoG II 21:56 17 Nov 2004

=IF(A1<=29.99,A1*5.25%,5.25%*29.99+3.25%*(A1-29.99))

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

See mcbess's iconic style animated for Mercedes-Benz

iPhone X news: Release date, price, new features & specs

Black Friday 2017 : date, sites participants & bonnes affaires