Closed Thread
Results 1 to 2 of 2

automatic markup calculation dependent on price vale

  1. #1
    Veg-man
    Guest

    automatic markup calculation dependent on price vale

    I need to create a sheet that will calculate markups on based on purchase
    price eg if cost = a markup = 200%, if cost =b markup = 150% if cost = c
    markup = 135%. I have tried following but get zero for an answer on any
    figure entered
    '=IF(OR(G6<=10),H6=G6*2,IF(OR(G6>10,G<30),H6=G6*1.5,IF(OR(G6>30),H6=G6*1.35)))


  2. #2
    Bob Phillips
    Guest

    Re: automatic markup calculation dependent on price vale

    This should work

    =IF(G6<=10,G6*2,IF(OR(G6>10,G6<30),G6*1.5,G6*1.35))

    entered into the cell H6

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "Veg-man" <Veg-man@discussions.microsoft.com> wrote in message
    news:6B3A74D7-D0E8-4775-85B5-EE6E566E6307@microsoft.com...
    > I need to create a sheet that will calculate markups on based on purchase
    > price eg if cost = a markup = 200%, if cost =b markup = 150% if cost = c
    > markup = 135%. I have tried following but get zero for an answer on any
    > figure entered
    >

    '=IF(OR(G6<=10),H6=G6*2,IF(OR(G6>10,G<30),H6=G6*1.5,IF(OR(G6>30),H6=G6*1.35)
    ))
    >




Closed 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