Function problem for questionnaire

[Waldo Hechter]

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

 

[shg]

Duplicate post

 

[Waldo Hechter]

Yes I realised that, and could not find an easy way to delete the question even though I created it.
Also can't find a way to mark the issue resolved in order to help other users.
If you could look into that I think it would be helpful.

Great forum Thx

Duplicate post