View Single Post
 
Old 02-07-2017, 02:41 PM
Excelsior44 Excelsior44 is offline Windows 8 Office 2016
Novice
 
Join Date: Feb 2017
Posts: 2
Excelsior44 is on a distinguished road
Default Excel 2016 "IF" Function Problem with 3 Ranges

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.
Reply With Quote