formula for multiplying three different rates for single product

[harsharmani]

hi

i have three different rates for one product

a= 10rs for 5nos and for 10nos rs30 and 15no rs40

i want a formaula when i type 5 in one cloum it should automatically multiply with rs10 and rate shd reflect in colum.. like wise if customer select 10 and 15 it shd multiply with 30 and 40

can i get tht type of formula in excel..

pls help me..

harsh

 

[shift-del]

Re: formuala for multiplyiing three different rates for single product

Harsh,

that would be my guess.
Tabelle1

	A	B	C	D	E	F

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:80px;"><col style="width:80px;"><col style="width:80px;"><col style="width:80px;"><col style="width:80px;"><col style="width:80px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=fff2cc]#fff2cc[/URL] , align: right"]10[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=e2efda]#e2efda[/URL] , align: right"]300[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ddebf7]#ddebf7[/URL] "]nos[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ddebf7]#ddebf7[/URL] "]rs[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ddebf7]#ddebf7[/URL] , align: right"]5[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ddebf7]#ddebf7[/URL] , align: right"]10[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ddebf7]#ddebf7[/URL] , align: right"]10[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ddebf7]#ddebf7[/URL] , align: right"]30[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ddebf7]#ddebf7[/URL] , align: right"]15[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ddebf7]#ddebf7[/URL] , align: right"]40[/TD]

</tbody>

Formeln der Tabelle

Zelle Formel B1 =A1*LOOKUP(A1,$E$2:$E$4,$F$2:$F$4) <tbody> </tbody>

<tbody>
</tbody>

Excel Tabellen im Web darstellen >> Excel Jeanie HTML 4.8

 

[harsharmani]

Re: formuala for multiplyiing three different rates for single product

Harsh,

that would be my guess.
Tabelle1

	A	B	C	D	E	F
		nos	rs

<tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]300[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]5[/TD]
[TD="align: right"]10[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]10[/TD]
[TD="align: right"]30[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]15[/TD]
[TD="align: right"]40[/TD]

</tbody>

Formeln der Tabelle

Zelle Formel B1 =A1*LOOKUP(A1,$E$2:$E$4,$F$2:$F$4) <tbody> </tbody>

<tbody>
</tbody>

Excel Tabellen im Web darstellen >> Excel Jeanie HTML 4.8

[TABLE="width: 780"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD] [TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]product[/TD]
[TD]a[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]d[/TD]
[TD]e[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]bioprine[/TD]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl65, width: 118"]Rs 10 for 5 product[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 73"]
<tbody>[TR]
[TD="class: xl65, width: 73"]rs 20 for 10 product [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 126"]
<tbody>[TR]
[TD="class: xl65, width: 126"]rs 30 for 15 product[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 153"]
<tbody>[TR]
[TD="class: xl65, width: 153"]no of product required [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]rate[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 182"]
<colgroup><col></colgroup><tbody>[TR]
[TD]customer will enter desired no of product in D colum and rate shd efect in E coloum[/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]10[/TD]
[TD]20[/TD]
[TD]30[/TD]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 182"]
<colgroup><col></colgroup><tbody>[TR]
[TD]if I type from 1 to 15 in D column automatically the rate shd come in E colum[/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] please help me and do the need full[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]