+ Reply to Thread
Results 1 to 4 of 4

Worksheet Formula

  1. #1
    Registered User
    Join Date
    01-17-2008
    Posts
    2

    Unhappy 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. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Is this what you mean with cost in A2 and percentage in C1 and this in B2

    =A2+A2*$C$1
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    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. #4
    Registered User
    Join Date
    01-17-2008
    Posts
    2

    Talking It Worked!!

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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