# Worksheet Formula

1. ## Worksheet Formula

I've been working on this for hours to no avail.

I have one column with OUR COST, one column with OUR PRICE, one column with a percentage at the top (right now it's at 4%). I want to be able to show our mark up in the percentage column yet at the same time be able to change the percentage (ie from 4% to 5% and so on) and have the column change per the percentage. Then I want to ADD the percentage with OUR COST to create OUR PRICE. I hope this makes sense! Please help!!!!

2. Is this what you mean with cost in A2 and percentage in C1 and this in B2

=A2+A2*\$C\$1

3. OK, I'll have a stab....

If Cost is in A2 and % in C1 then this formula would give the markup in C2, I think

=A2*C\$1

To get the price in B2 use this formula

A2+C2

4. ## It Worked!!

I used both formulas!!! Thank you sooooo much!

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