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