need help with calculations

[needshelpinexcel]

I am trying to determine a margin based on my total cost of products

For example
I have multiple line items with a cost

I want to add a margin to each line item depending on it range
<1000 add 45% margin
<5000 but greater than 1001 add 43% margin
<10000 but greater tan 5001 add 35% margin

etc

 

[Michael M]

Try

=IF(A1<=1000,A1*1.45,IF(A1<=5000,A1*1.43,A1*1.35))

but...what does etc mean....how many more conditions are there ???

 

[needshelpinexcel]

our prices can go as high as 60000

 

[jtakw]

Hi,

You can also use LOOKUP, as Michael M asked, what are the "rest" of the requirements ?

This formula, as is, anything Over 10000 also adds 35% margin:

Book1
	A	B	C
1	1000		1450
2	5001		6751.35
3	10000		13500
4	1001		1431.43
5	5001		6751.35
6	20000		27000
Sheet413

Cell Formulas
Range	Formula
C1	=A1*LOOKUP(A1,{0,1001,5001},{1.45,1.43,1.35})

 

[needshelpinexcel]

ok so I have multiple rows that I am adding up in sections
for instance I have 2 rows of numbers in one section
General
Prep time 8 hrs $55/hr $440
Tools 1 QY $500/Material cost $500

This goes on for multiple sections
at the bottom of the sheet I have a subtotal $940


On the second sheet I have each section listed with subtotal


So


General $940


Paint $1500


Wax $500


So here is what I want to do.
If the subtotal on page 1 isbetween a certain amount I want to multiple the subtotal of each section onpage 2 by a certain percentage so that the percentages are part of the sum that is then subtotatalled at the bottom