Thread
: [Solved]
Excel 2016 "IF" Function Problem with 3 Ranges
View Single Post
02-07-2017, 05:30 PM
jeffreybrown
Windows Vista
Office 2007
Expert
Join Date: Apr 2016
Posts: 673
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",""))))
jeffreybrown
View Public Profile
Find all posts by jeffreybrown