#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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
|
|||
|
|||
Thank you very much! It worked! Jesus Christ , I'd never have thought of this idea.
|
#4
|
|||
|
|||
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 |
|
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 |
Problem with "Next page" section break automatically turning into "Odd or Even Page" | c_gallagher25 | Word | 1 | 02-12-2014 04:27 PM |
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 |