Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: tricky formula

  1. #1
    Guest

    Default

    I am trying to write a formula which will give me the whole sale cost working backwards from the retail price given the % mark up required. For example an iten reatiling for $6.00 need to wholesale at $3.16 at a 90% markup. I have writen a siple formula which divides the reail cost by 1.9 which gives me the right answer, What I need is a formula where I can vary the %.


  2. #2
    New Member
    Join Date
    Feb 2002
    Posts
    47
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You could use a cell address in your formula where you placed the %, and then change the value in the cell address.

    For example

    B2 is the cost a1 is the %. Change a1's value and the formula will change.
    =(b2*a1)

  3. #3
    Guest

    Default

    I have tried this but it does not give the correct answer ?
    On 2002-02-23 18:54, Paul-Johnson wrote:
    You could use a cell address in your formula where you placed the %, and then change the value in the cell address.

    For example

    B2 is the cost a1 is the %. Change a1's value and the formula will change.
    =(b2*a1)

  4. #4
    Guest

    Default

    EUREKA - I've solved my own problem.
    If A1 contains the retail cost and B1 the % then this formula works =A1/(B1+1)
    So simple really !!!!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •