Problem with IF Formula

[pradeepm]

Please help me in the below formula.

=IF(A3>=1,"1",IF(B3>=1,"1",IF(A4>=1,"3",IF(B4>=2,"3",IF(A5>=1,"6",IF(B5>=3,"6",F(A6>=1,"10",IF(B6>=4,"10",IF(A7>=1,"15",IF(B7>=5,"15",IF(A8>=2,"2",IF(B8>=1,"2",IF(A9>=2,"5",IF(B9>=2,"5",IF(A10>=3,"13",IF(B10>=3,"13",IF(A11>=4,"21",IF(B11>=4,"21",IF(A12>=5,"25",IF(B12>=5,"25",IF(A13>=3,"22",IF(B13>=5,"22",IF(A14>=3,"8",IF(B14>=2,"8",IF(A15>=4,"12",IF(B15>=2,"12",IF(A16>=5,"16",IF(B16>=2,"16",IF(A17>=3,"4",IF(B17>=1,"4",IF(A18>=4,"7",IF(B18>=1,"7",IF(A19>=2,"9",IF(B19>=3,"9",IF(A20>=5,"11",IF(B20>=1,"11",IF(A21>=2,"14",IF(B21>=4,"14",IF(A22>=4,"17",IF(B22>=3,"17",IF(A23>=3,"18",IF(B23>=4,"18",IF(A24>=2,"19",IF(B24>=5,"19",IF(A25>=5,"20",IF(B25>=3,"20",IF(A26>=5,"23",IF(B26>=4,"23",IF(A27>=4,"24",IF(B27>=5,"24"))

I have two different figures in Column "A" and Column "B". I want to apply a IF formula in which the Result will be a different number mentioned in IF formula.

Attached Excel file with detail explanation.

Regards,
Pradeep

 

[awoohaw]

@pradeepm can you install the xl2bb add-in which makes it easier for people to help you (so we do not need to recreate your worksheet)?

 

[shinigamilight]

You should try to make a table and lookup values in it instead of manually typing out all the results. Do a partial match.

 

[awoohaw]

I suggest using a concatenated (with "&" character) and use XLOOKUP or INDEX(MATCH)

Mr Excel Questions.xlsx
	A	B	C	D	E
1	A	B	Result
2	1	1	1
3	1	2	3
4	1	3	16
5	1	4	10
6	2	5	15
7	2	1	2
8
9
10	A	B	LOOKUP
11	2	5	15		=INDEX(C2:C7,MATCH(A11&B11,A2:A7&B2:B7,0))
12			15		=XLOOKUP(A11&B11,A2:A7&B2:B7,C2:C7)
Sheet4

Cell Formulas
Range	Formula
C11	C11	=INDEX(C2:C7,MATCH(A11&B11,A2:A7&B2:B7,0))
C12	C12	=XLOOKUP(A11&B11,A2:A7&B2:B7,C2:C7)
E11:E12	E11	=FORMULATEXT(C11)

Cells with Data Validation
Cell	Allow	Criteria
A11	List	=$A$2:$A$7
B11	List	=$B$2:$B$7

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Problem with IF Formula
and here I want to apply one single formula with 25 If conditions
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.