Need Function for questionnaire totals Pls

Waldo Hechter

New Member
Joined
Jan 21, 2014
Messages
3
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

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
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)

Adjust the range reference
 
Upvote 0
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)

Adjust the range reference
 
Upvote 0
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)

Adjust the range reference
 
Upvote 0
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")))
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,974
Members
448,537
Latest member
Et_Cetera

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top