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.

Hello & Welcome to the Forum,

Try this in A3...

=IF(COUNTA(A1:A2)<>2,"",IF(AND(A1>A2*90%,A1<A2*110 %),"Normal",IF(A1>=A2*110%,"Overweight",IF(A1<=A2* 90%,"Underweight",""))))

Thank you very much! It worked! Jesus Christ , I'd never have thought of this idea.

Very happen to help and glad you see the power in Jesus Christ.

He has definitely given me insight to help others and died in my place for which I am thankful everyday.

God Bless, Jeff