Spread Sheet Help again

  • Thread starter Thread starter califman1961
  • Start date Start date
C

califman1961

Here it is hope someone can help me out one more time?

I sell something for $25.00 or lower the fee is 5.25% ($1.31), But if
its more $25.01 to $1,000.00 fee is 5.25% of the initial $25.00
($1.31), plus 2.75% ($0.68)of the remaining closing value balance
($25.01 to $1,000.00)

Cell H1 is $25.00 then Cell J1 is $1.31 (5.25%)
Cell H1 is $25.01 then Cell J1 is $1.31 (5.25%)plus 2.75% or $1.99
Can I have them in the same cell somehow is this possable?
Thanks for the help
 
Back
Top