Multiple IF calculating two cells and totalling

Hi All,

I was wondering if it is possible to count a number from two cells and add them together? Example below.

In one cell I would like to be able to know the following:

If number in C4 is less than 5 in C4 then score it 1
If number in C4 is between 6-10 then score it 2
If number in C4 is between 11-26 then score it 3
If number in C4 is greater than 27+ then score it 4
If number in C5 is less than 4 then score it 1
If number in C5 is between 5-10 then score it 2
If number in C5 is between 11-23 then score it 3
If number in C5 is greater than 24+ then score it 4

Then combine the two numbers for a total. So if C4 was scored 1 and C5 is scored 2 then the formulae would return 3.

So far I have this formulae that is counting one cell =IF(B4<5,1,IF(B4<10,2,IF(B4<26,3,4)))

I hope this makes sense : )

Which version of Excel are you currently using?

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Better done with lookup tables:

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	C	D	E	F	G	H	I	J	K
4	5		3	=VLOOKUP(C4,$G$7:$H$10,2,1)+VLOOKUP(C5,$J$7:$K$10,2,1)
5	6
6
7					0	1		0	1
8					6	2		5	2
9					11	3		11	3
10					27	4		24	4

Sheet: Sheet1

Or try

Formula:

Please Login or Register  to view this content.

Thanks for the rep .