Microsoft Office Forums Excel 2016 "IF" Function Problem with 3 Ranges
 Register FAQ Search Today's Posts Mark Forums Read

#1
02-07-2017, 02:41 PM
 Excelsior44 Windows 8 Office 2016 Novice Join Date: Feb 2017 Posts: 2
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.

#2
02-07-2017, 05:30 PM
 jeffreybrown Windows Vista Office 2007 Expert Join Date: Apr 2016 Posts: 613

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",""))))
#3
02-07-2017, 05:37 PM
 Excelsior44 Windows 8 Office 2016 Novice Join Date: Feb 2017 Posts: 2

Quote:
 Originally Posted by jeffreybrown Hello & Welcome to the Forum, Try this in A3... =IF(COUNTA(A1:A2)<>2,"",IF(AND(A1>A2*90%,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.
#4
02-07-2017, 05:46 PM
 jeffreybrown Windows Vista Office 2007 Expert Join Date: Apr 2016 Posts: 613

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

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post Sadodare Excel 0 08-01-2016 11:15 AM BudVitoff Office 0 04-03-2015 09:17 PM c_gallagher25 Word 1 02-12-2014 04:27 PM KIM SOLIS Excel 1 11-05-2011 01:57 AM sword.fish Excel 0 02-26-2010 02:09 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 01:51 PM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top