Results 1 to 5 of 5

Need formula that calculating price or(and) margin!

Threaded View

  1. #1
    Registered User
    Join Date
    07-21-2014
    Location
    Chatsworth
    MS-Off Ver
    2007
    Posts
    6

    Question Need formula that calculating price or(and) margin!

    Hi, Guys.

    This is my 1st post. LOL
    It is nice to meet you all of you.

    I am working quote sheet as attached.
    I am getting price based on Margin % but after I got price sometimes I'd like to change the certain number.

    For example. Price came out $0.95 and I changed to $1.00 without changing margin number.

    In this case If I put new number on price, my formula is gone.

    I need formula that works both way. If I change either margin% or price they work together.

    I really need your help~

    Thank you in advance.

    Steve
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculating a selling price from a given margin.
    By rwl518p in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-05-2015, 05:36 PM
  2. [SOLVED] Calculate Sales price with Net Margin 10% Goal, if Cost goes up or down
    By Bitto in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-22-2013, 07:26 AM
  3. Margin, RRP and Cost Price Calculation assistance
    By scottmjohnson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-24-2012, 05:55 AM
  4. Replies: 1
    Last Post: 07-19-2012, 01:28 PM
  5. Margin/price markup as %
    By andycannon in forum Excel General
    Replies: 5
    Last Post: 06-17-2010, 06:30 AM

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