automatic markup calculation dependent on price vale

V

Veg-man

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

Bob Phillips

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