posted on October 22, 2001 05:23:27 AM
You basically use the same one richierich gave you in the FVF thread but change the percentages based on what PP level you are.
For example, if you are a business account, you can use:
=IF(columnrow>0,sum((columnrow*2.296%)+.30),0)
This says, if your amount is greater than zero, then muliply that amount times 2.296% (the amount for the business account) plus the thirty cents flat fee.
If you have a premier account, then you'll need to revise it based on your bonus.
Don't forget, for PP, the columnrow would be the sum of the final price AND shipping as opposed to FVF which is on the final price ONLY.
