Conditional calculation in Excel

[ctsgreddy]

I have four possible combinations that can happen.. Based on the combination, I need to multiply different coulmns and put it in a cell.

Could you please send me the syntax please...??

 

[jeffreybrown]

Do you have a sample of your data you could post...

http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

 

[ctsgreddy]

Please find the sample below

type location rate

A India $10
A USA $40
B India $12
B USA $45




Type Location hours $$

A India 35 (=hours * rate)
B USA 40 (=hours * rate)


Based on the location and resource type, I have different rate. I need to multiply my hours with appropriate rate coming out of the first table

 

[jeffreybrown]

I'm sure somebody will let me know the right way to do this, but does this work...

Excel Workbook
	K	L	M	N	O
4	Type	Location	Rate
5	A	India	$10	35	$350
6	A	USA	$40
7	B	India	$12
8	B	USA	$45	40	$1,800
9
10
11	A India	35
12	B USA	40
Sheet2

 

[lenze]

Create a Table like this and use INDEX(MATCH)

  A     B  C  D  
1       A  B  C  
2 INDIA 10 12 14 
3 USA   40 45 50 
4 CHINA 50 60 70 
5                
6                
7 USA            
8 B           45 
Sheet2
[Table-It] version 09 by Erik Van Geit

RANGE FORMULA 
D8    =INDEX(B2:D4,MATCH(A7,A2:A4,0),MATCH(A8,B1:D1,0))
[Table-It] version 09 by Erik Van Geit

lenze