# automatic markup calculation dependent on price vale

1. ## 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. ## 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)
))
>

##### Users Browsing this Thread

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

#### 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