Google Sheets Formula for Margin & Totals
Budget: $30 – $250 CAD
I'm seeking an expert in Google Sheets who can create a formula for me. The formula needs to:
- Add a margin to the product price, calculated as a percentage of the cost.
- Include the credit card surcharge, which is a percentage of the total.
- Calculate HST (Harmonized Sales Tax) for a final grand total.
Ideal candidates should have a deep understanding of Google Sheets and experience with financial calculations. Please provide previous examples of similar projects you've completed.
I've attached a screen shot of what I've created so far (which isn't much) I'm having trouble with material margin, credit card surcharge which won't be applicable every time and HST to give me a total of all 3 based off the subtotal price when appropriate quantities are entered.
- Add a margin to the product price, calculated as a percentage of the cost.
- Include the credit card surcharge, which is a percentage of the total.
- Calculate HST (Harmonized Sales Tax) for a final grand total.
Ideal candidates should have a deep understanding of Google Sheets and experience with financial calculations. Please provide previous examples of similar projects you've completed.
I've attached a screen shot of what I've created so far (which isn't much) I'm having trouble with material margin, credit card surcharge which won't be applicable every time and HST to give me a total of all 3 based off the subtotal price when appropriate quantities are entered.