Excel 2016 "IF" Function Problem with 3 Ranges

[Excelsior44]

Hello fellow Excel users,



Just registered because I would like someone to help me with my understandings about Excel.

I'm not a person who regularly works with Excel and my experience is very limited, that is why I am asking for help with this example that I have been struggling within the last 2 days.

Example:

A1= Is the current weight of a person.
A2= Is the ideal weight of a person.
A3= Is the cell where it should indicate whether the person's is underweight, in the norm or overweight.

The condition is as follows:
- The normal (or in the norm ) weight varies from ideal weight -(minus) 10% to ideal weight +(plus) 10%
- If the weight is bellow ideal weight -(minus) 10% it should indicate - Underweight
- If the weight is over ideal weight +(plus) 10% it should indicate - Overweight

Biggest problem for me is the middle gap and how do I input the percentages.

Thank you in advance.