# Need Function for questionnaire totals Pls

#### Waldo Hechter

##### New Member
Hi

Thank you for those who will help me.

I have a questionnaire that generates a number sum total between 0 and 40. (in cell A1)

The totals represent the following attributes:

Normal 0-13
Borderline 14-16
Abnormal 17-40

How do I show the value, Normal or Borderline or Abnormal (in cell B1) by referencing cell A1

Note: I'm new to functions

Thanks again

### Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

#### royUK

##### Well-known Member
Use VLOOKUP for a nearest match - enter True not false. Set the table up as below

 0 Normal 14 Borderline 16 Abnormal

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>

=VLOOKUP(J4,G4:H6,2,TRUE)

#### royUK

##### Well-known Member
Use VLOOKUP for a nearest match - enter True not false. Set the table up as below

 0 Normal 14 Borderline 16 Abnormal

<colgroup><col width="64" span="2" style="width: 48pt;"></colgroup><tbody>
</tbody>

<colgroup><col width="64" span="2" style="width: 48pt;"></colgroup><tbody>
</tbody>

=VLOOKUP(J4,G4:H6,2,TRUE)

#### royUK

##### Well-known Member
Hi

Use VLOOKUP for a nearest match - enter True not false. Set the table up as below

 0 Normal 14 Borderline 16 Abnormal

<colgroup><col width="64" span="2" style="width: 48pt;"></colgroup><tbody>
</tbody>

<colgroup><col width="64" span="2" style="width: 48pt;"></colgroup><tbody>
</tbody>

=VLOOKUP(J4,G4:H6,2,TRUE)

#### Billy C

##### Board Regular
You could use a nested if statement

=IF(AND(A1>=0,A1<=13),"Normal",IF(AND(A1>=14,A1<=16),"Borderline",IF(AND(A1>=17,A1<=40),"Abnormal")))

#### Waldo Hechter

##### New Member
Thank you royUK

If I had more skill I could have used this I'm sure unfortunately I could not use this one.

Hi

Use VLOOKUP for a nearest match - enter True not false. Set the table up as below

 0 Normal 14 Borderline 16 Abnormal

<tbody>
</tbody>

<tbody>
</tbody>

=VLOOKUP(J4,G4:H6,2,TRUE)

#### Waldo Hechter

##### New Member
This worked perfectly, I could even adjust it to perform a similar function.

Thank you

You could use a nested if statement

=IF(AND(A1>=0,A1<=13),"Normal",IF(AND(A1>=14,A1<=16),"Borderline",IF(AND(A1>=17,A1<=40),"Abnormal")))

Replies
1
Views
466
Replies
1
Views
670
Replies
1
Views
172
Replies
6
Views
929
Replies
2
Views
180

1,195,632
Messages
6,010,791
Members
441,569
Latest member
PeggyLee

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back