|
02-07-2017, 05:37 PM
|
|
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 %),"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.
|