Login

u/PhilGooodInc

▲ 1 r/googlesheets

Formula for calculating variable percentage fees

I am trying to create a formula around some new eBay fees, which changed from a fixed percentage to variable percentage depending on value. This sort of thing is completely new to me so have no idea how to tackle it.

I am using $50 as an example, Ideally, I would like to be able to

  1. Enter a number, and get the final amount buyer pays (since they pay the fee) eg. I enter $50 in one cell and result is $53.70 in another cell.
  2. Enter the number to see the inverse, eg I want buyer to pay $50, and I see what amount I need to list it at to appear as ($46.51)

The rates are

  • $0.30 per item
  • 8% of the item price up to AU $20, and
  • 6% of any portion of the item price from $20 to $500, and
  • 4% of any portion of the item price from $500 to $5,000

Any tips on how to achieve this would be greatly appreciated

reddit.com
u/PhilGooodInc — 2 days ago
▲ 16 r/PokemonTCG

What "condition" would you say this card in? (Sanity Check - not for grading)

Recently bought off eBay, was listed as LP "excellent". Was photographed in a way that covered a lot of the flaws (bad lighting, beige coloured wall as background).

The front is peeling off on the top right corner, has a visible crease on the front top, multiple surface scratches front and back, visible crease in rear where it peeling and those corners... even my loose base set energy cards dont have that sort of wear after 25 years.

I normally dont deal with cards with this kind of wear/damage since I actually take care of my cards. I'd consider it HP "Poor", but am I being too harsh?

After contacting the seller they are adamant that it is still in "excellent" condition...

u/PhilGooodInc — 5 days ago