| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
16 diffetent if functions for 2 criteria
I am using excel to calculate BMI for children. I have 16 different if
functions entered and want to set a criteria for using each function. Basically I want to use one formula for 5 year old boys, another for 5 yr. old girls, one for 6 year old boys, and another for 6 year old girls, etc. I have the formulas in a different sheet. I've tried countifs but I can't seem to get that to work. Example below: A B C D E F G Name Gender Age Height Weight BMI Category |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| database functions and criteria | Excel Worksheet Functions | |||
| Using wildcards in criteria for sumifs functions | Excel Discussion (Misc queries) | |||
| SUM Functions with multiple criteria | Excel Discussion (Misc queries) | |||
| Non-consecutive criteria database functions | Excel Worksheet Functions | |||
| Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
Threaded Mode
