| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
if greater or lesser than
Hello, can someone give me some help with this please
H200 is age I need to add a new age group which is 40+ I have tried to add this to the formula but have trouble getting it to work =if(H20040,H200<50,"40+" =IF(H200=50,"vet",IF(H200=20,"open",IF(H200=18, "under 20",IF(H200=16,"under 18",IF(H200=14,"under 16",IF(H200<14,"under 14","false")))))) all help much appreciated regards Ditchy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to show data greater than 10 in pivot table | Excel Discussion (Misc queries) | |||
| if greater then 99 then 1 if greater then 199 then two | Excel Worksheet Functions | |||
| Help with SUMIF, INDEX, LOOKUP Please !! | Excel Worksheet Functions | |||
| Help w/ SUMIF ; INDEX | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Threaded Mode
