Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Nov 19, 2012
user Houman said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/3LwMpWxRhnQ)
IF function formula
I'm looking to create a nested IF function.
Here is an example
Jack, Age 6
Jill, Age 13
Bill Age 18
Martha Age 26
Jeremy Age 64
and there are several groups
If your aged between
So i would want the spreadsheet to realise Jack is 6 years old and belongs in the group apple, jeremy for elephant and so on.
If anyone could provide me with the formula of how to do this I would be very grateful.