Excel 2016 "IF" Function Problem with 3 Ranges

		Microsoft Office Forums > Microsoft Excel > Excel
Excel 2016 "IF" Function Problem with 3 Ranges

FAQ

Thread Tools

Display Modes

02-07-2017, 05:30 PM

jeffreybrown jeffreybrown is offline

Windows Vista Excel 2016 "IF" Function Problem with 3 Ranges

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

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",""))))

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:57 PM.