I want to know the formula for a problem

[krishco]

Dear Sir,
I have a problem
I want a formula for the problem
Problem is: In a cell I have number of days (the days btw 2 dates)
Keeping that as reference:
I have 3 slabs:
slab 1 : if the days are more than 5 and less than or equal 10 the number of days should display in a cell next to the slab amount and multiply by slab 1 amount Rs.2000 ( the other 2 slabs should be zero)
Slab 2 : if the days are more than 10 and less than or equal 15 the number of days should display in a cell next to the 2nd slab and multiply by slab 2 amount Rs.8000 ( the other 2 slabs should be zero)
Slab 3 : if the days are more that 15 and less than or equal to 20 the number of days should display in a cell next to the 3rd slab and multiply by Slab 3 amount Rs.12000 ( the other 2 slabs should be zero)

Regards,
Murali Krishna

 

[kweaver]

Welcome to the Forum.

How's this?

Excel 2010
	A	B	C	D	E	F	G
1	# Days	Slab1 Amt		Slab2 Amt		Slab3 Amt
2	6	100	200,000	200		300
3	12	100		200	1,600,000	300
4	20	100		200		300	3,600,000
Sheet5

Cell Formulas
Range	Formula
C2	=IF(AND($A2>5,$A2<=10),$B2*2000,"")
E2	=IF(AND($A2>10,$A2<=15),$D2*8000,"")
G2	=IF(AND($A2>14,$A2<=20),$F2*12000,"")

 

[kweaver]

Typing error. G2 should be: =IF(AND($A2>15,$A2<=20),$F2*12000,"")

By the way, you didn't say what should happen if the days were >20

 

[krishco]

Thank you sir, it is working. after 20 the slab remains same.