Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-07-2017, 02:41 PM
Excelsior44 Excelsior44 is offline Excel 2016 "IF" Function Problem with 3 Ranges Windows 8 Excel 2016 "IF" Function Problem with 3 Ranges Office 2016
Novice
Excel 2016 "IF" Function Problem with 3 Ranges
 
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
  #2  
Old 02-07-2017, 05:30 PM
jeffreybrown jeffreybrown is offline Excel 2016 "IF" Function Problem with 3 Ranges Windows Vista Excel 2016 "IF" Function Problem with 3 Ranges Office 2007
Expert
 
Join Date: Apr 2016
Posts: 613
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

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",""))))
Reply With Quote
  #3  
Old 02-07-2017, 05:37 PM
Excelsior44 Excelsior44 is offline Excel 2016 &quot;IF&quot; Function Problem with 3 Ranges Windows 8 Excel 2016 &quot;IF&quot; Function Problem with 3 Ranges Office 2016
Novice
Excel 2016 &quot;IF&quot; Function Problem with 3 Ranges
 
Join Date: Feb 2017
Posts: 2
Excelsior44 is on a distinguished road
Default

Quote:
Originally Posted by jeffreybrown View Post
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.
Reply With Quote
  #4  
Old 02-07-2017, 05:46 PM
jeffreybrown jeffreybrown is offline Excel 2016 &quot;IF&quot; Function Problem with 3 Ranges Windows Vista Excel 2016 &quot;IF&quot; Function Problem with 3 Ranges Office 2007
Expert
 
Join Date: Apr 2016
Posts: 613
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Google "=Filter()" function excel equivalent. Sadodare Excel 0 08-01-2016 11:15 AM
"Open Recent" and "More..." in Excel and Word BudVitoff Office 0 04-03-2015 09:17 PM
Excel 2016 &quot;IF&quot; Function Problem with 3 Ranges Problem with "Next page" section break automatically turning into "Odd or Even Page" c_gallagher25 Word 1 02-12-2014 04:27 PM
Excel 2016 &quot;IF&quot; Function Problem with 3 Ranges How to "deactivate" the Excel's SAVE function KIM SOLIS Excel 1 11-05-2011 01:57 AM
"Microsoft Excel Application" missing in the "Component Services" on win08 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.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft