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

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" <[email protected]> wrote in message
news:[email protected]...
> 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)
))
>