+ Reply to Thread
Results 1 to 6 of 6

Formula required to calculate prices whilst considering other conditions

  1. #1
    Registered User
    Join Date
    08-24-2013
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    2

    Formula required to calculate prices whilst considering other conditions

    Hi,
    I am trying to find a solution and am hoping you clever guys can help me out.(first post so go easy

    Problem:

    I would like to adjust the sales prices for a range of products so we have sensible and structured prices. At the moment we have some bigger items that are cheaper than smaller items and a few other anomolies.

    Ideally I would like to have the sales price increase in line with the size and also a reasonably consistent margin accross the products.

    However I have to ensure that:

    1. The total price paid by the customer will stay same so they will be in the same position.
    2. The profit made is still the same.

    I have uploaded an extract of this and am hoping some intelligient individual can demonstrate the best way of tackling this as Im struggling.

    The expected result would be a revised sales price whilst complying with the above conditions.

    The upload is merely a small extract.

    Im reasonable on excel but no where near as good as you gurus
    Attached Files Attached Files
    Last edited by NIVLAG; 08-24-2013 at 09:18 AM. Reason: Title adjusted

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Please can someone clever help find a solution to my problem, Formula & Math help requ

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    08-24-2013
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Formula required to calculate prices whilst considering other conditions

    Title updated - sorry.

    It's a difficult problem to put into words if a mod feels this could be articulated better I have no objection to them revising the title

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Formula required to calculate prices whilst considering other conditions

    Thanks for changing the topic title.

    What would be the desired (expected) result.

    Please add it in your excel file and post it.

  5. #5
    Registered User
    Join Date
    08-23-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Formula required to calculate prices whilst considering other conditions

    Deleting - sorry posted in wrong thread.
    Last edited by boggs; 08-24-2013 at 10:43 AM.

  6. #6
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Formula required to calculate prices whilst considering other conditions

    Did you upload the wrong file? I see no formulas in row 1 (all titles) and none in column L.

    Oeldere is suggesting you manually enter the results you'd like to see in several places and highlight those cells as the ones you want to automate.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] SUMPRODUCT(SUMIF or other clever solution!
    By Torleif in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-07-2012, 02:09 PM
  2. I can't find the solution to my problem...
    By Paul in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-31-2006, 01:40 PM
  3. sum if problem, trying to find best solution
    By shalombi in forum Excel General
    Replies: 5
    Last Post: 05-31-2006, 07:57 AM
  4. Replies: 3
    Last Post: 02-16-2006, 07:00 AM
  5. Easy solution need for find problem
    By Neil Atkinson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2005, 10:05 PM

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