formula

[Bacchus]

Can someone please help me with the forumla below. The selling price is $40

thanks

5.25% of the initial C$30.00 (C$1.58), plus 3.25%of the remaining closing
value balance (C$30.01 to C$1,200.00)

--

Bubblefast Canada
Toronto, Ontario
Toll Free 1 877 599 (SHIP) 7447
Fax: 416 247 9884
www.bubblefastcanada.com
www.stores.ebay.ca/BubbleFAST-Canada
[email protected]

 

[Bob Umlas]

=5.25%*MIN(30,A1)+3.25%*(A1-30)

 

[Bob Phillips]

=ROUND(MIN(A1,30)*5.25%,2)+ROUND(MAX(A1-30,0)*3.25%,2)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)