Results 1 to 10 of 10

Help with formula that I can`t figure out

Threaded View

  1. #1
    Registered User
    Join Date
    04-10-2012
    Location
    Brooklyn NY
    MS-Off Ver
    Excel 2003
    Posts
    16

    Help with formula that I can`t figure out

    Hi
    Im using Excel X (an older version prior Excel 2003) and I need to change a price list with a formula (I think...)
    To each price I need to add 120% + $91. To this number I need to add +3% x3%.....all in one formula.
    Example of what I`m doing manually now. Starting price is $243.

    $243x120%= $291.6
    291.6+91= $382.6
    382.6+3%x3%= $11.82
    382.6+11.82= $394.42

    $394.42 is the adjusted number I need.

    What`s the correct formula to do this? Is it possible to apply the formula to the entire price list at once, and how you do it? Lastly instead of creating a new list of price next to the first I would like the original price list to change in to the new results from the formula calculation.
    I have limited Excel knowledge so please be as clear and specific as possible.
    Thank you so much for your help

    Robert
    Last edited by sufirosso; 04-10-2012 at 06:55 PM.

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