round up total

[kevin wilde]

Sales 25 125

Salary £2,000
Maximum Sales 80

Salary Budget £625 £3,125

Answer £2,000 £4,000

Hi can someone help I am a beginner with excel

How do I create a formula for my problem above

The monthly salary of 1 person is £2000 - they can do a maximum of 80 sales

for 25 sales my calculation gets me £625 but i need 1 person @ £2000

for 125 sales my calculation gets me £3125 but i need 2 people @ £2000 = £4000

 

[Snakehips]

Book1
	A	B	C
1	Salary per Person	$2,000.00
2	Max Sales per person	80
3
4	Expected Sales	125	<< Enter
5	Salary budget	$4,000.00
Sheet4

Cell Formulas
Range	Formula
B5	B5	=ROUNDUP(B4/B2,)*B1

Hope that helps

 

[kevin wilde]

Book1
	A	B	C
1	Salary per Person	$2,000.00
2	Max Sales per person	80
3
4	Expected Sales	125	<< Enter
5	Salary budget	$4,000.00
Sheet4

Cell Formulas
Range	Formula
B5	B5	=ROUNDUP(B4/B2,)*B1

Hope that helps

sorted many thanks