IF functions

%3CLINGO-SUB%20id%3D%22lingo-sub-1550701%22%20slang%3D%22en-US%22%3EIF%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1550701%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20having%20problems%20with%20the%20right%20formula%20for%20this%20argument%3B%20%26lt%3B25years%20%3Dboys%2C%20between%2025-34%3D%20Adults%2C%2035-64%20%3D%20Seniors%2C%20%26gt%3B64%20%3D%20Elders.%20Any%20help%20pls%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1550701%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1550982%22%20slang%3D%22de-DE%22%3ESubject%3A%20IF%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1550982%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F742522%22%20target%3D%22_blank%22%3E%40f500%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22text-wrap%20tlid-copy-target%22%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EEnclosed%20the%20file%20with%20a%20proposed%20solution%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3E...%20if%20the%20answer%20helped%20you%2C%20please%20tick%20as%20the%20correct%20answer%20so%20that%20others%20can%20also%20find%20out%20from%20it%2C%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3Ea%20little%20like%20would%20%20be%20good%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20%3CSPAN%3ENikolino%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1551312%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1551312%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F742522%22%20target%3D%22_blank%22%3E%40f500-%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20variant%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20628px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F208559i97C70624D5E29B94%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1552568%22%20slang%3D%22en-US%22%3EBetreff%3A%20IF%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1552568%22%20slang%3D%22en-US%22%3EThank%20you%2C%20this%20has%20been%20helpful.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1552578%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1552578%22%20slang%3D%22en-US%22%3EThank%20you%2C%20I%20love%20this%20response!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1553773%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1553773%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F742522%22%20target%3D%22_blank%22%3E%40f500-%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi, I am having problems with the right formula for this argument; <25years =boys, between 25-34= Adults, 35-64 = Seniors, >64 = Elders. Any help pls?

5 Replies
Highlighted

@f500- 

Enclosed the file with a proposed solution
... if the answer helped you, please tick as the correct answer so that others can also find out from it,
a little like would also be good


Nikolino
I know I don't know anything (Socrates)

 

Highlighted

@f500- 

As variant

image.png

Highlighted
Thank you, this has been helpful.
Highlighted
Thank you, I love this response!
Highlighted

@f500- , you are welcome