# How to add a profit margin to a total?

1. ## How to add a profit margin to a total?

Hi Everyone,

just wondering how I can automatically add a margin, say 15% to the total of a row.

For example,
f G

21 plumbing \$2500 \$375
22 landscaping \$3200 \$480
23 Kitchen \$7200 \$1080

The way I have it at the moment is that column G is =(f21)*.15
which only gives me 15% of f21, but i would like to know f21 plus 15% as a total \$2875.

I know this is really basic, but I can't quite work it out!

Scott.

2. ## Re: How to add a profit margin to a total?

Sorry, when I posted this, my rows were squashed!
Meant to be like this

...................................f ................G

21........plumbing ..........\$2500......... \$375
22 .......landscaping ......\$3200......... \$480
23 .......Kitchen............ \$7200........ \$1080

3. ## Re: How to add a profit margin to a total?

Hi Scott- Paste this in G21 and copy down:
=F21*1.15

4. ## Re: How to add a profit margin to a total?

In G21, =F21*1.15

5. ## Re: How to add a profit margin to a total?

many thanks, spot on!

6. ## Re: How to add a profit margin to a total?

Profit is measured on sales, not cost. If you want 15% profit, divide by (1-15%).

E.g., for \$100 cost, the price would be \$117.65

7. ## Re: How to add a profit margin to a total?

True!...though I took OP to mean a 15 % MARKUP. Not seein' the word "profit" there.
OOPS! Just saw that profit is mentioned in the TITLE. Nice catch, shg!

8. ## Re: How to add a profit margin to a total?

Sorry, I should have just said 15% mark up to make it less confusing.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1