automatic markup calculation dependent on price vale

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Markup/Cost formula help... 1
my first excel experience (share portfolio) 2
Calculation...Is this a possibility? 3
making a pricing matrix 6
Advice on multiple macros, same code just a different column 9
Complex value lookup? (Excel 2003) 6
V lookup 1
Calculating from mutual share prices the correlation coeffiient of returns 5

Back
Top