SOLVED

IFS

%3CLINGO-SUB%20id%3D%22lingo-sub-3458447%22%20slang%3D%22en-US%22%3EIFS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3458447%22%20slang%3D%22en-US%22%3E%3CP%3ESilly%20and%20basic%20question%2C%20but%20why%20is%20this%20not%20working%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222022-06-02_08-07-33.jpg%22%20style%3D%22width%3A%20808px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-06-02_08-07-33.jpg%22%20style%3D%22width%3A%20808px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-06-02_08-07-33.jpg%22%20style%3D%22width%3A%20808px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-06-02_08-07-33.jpg%22%20style%3D%22width%3A%20808px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-06-02_08-07-33.jpg%22%20style%3D%22width%3A%20808px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-06-02_08-07-33.jpg%22%20style%3D%22width%3A%20808px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-06-02_08-07-33.jpg%22%20style%3D%22width%3A%20808px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-06-02_08-07-33.jpg%22%20style%3D%22width%3A%20808px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-06-02_08-07-33.jpg%22%20style%3D%22width%3A%20808px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-06-02_08-07-33.jpg%22%20style%3D%22width%3A%20808px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F377039iBAFA6F501E9E27AA%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222022-06-02_08-07-33.jpg%22%20alt%3D%222022-06-02_08-07-33.jpg%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3458447%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3458456%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3458456%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1392387%22%20target%3D%22_blank%22%3E%40KirkExcel%3C%2FA%3E%26nbsp%3BI%20suspect%20you%20are%20not%20on%20Excel%202019%20or%20later.%20True%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3458489%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3458489%22%20slang%3D%22en-US%22%3EGosh%2C%20I%20do%20have%202019%2C%20but%20was%20using%202016%20in%20this%20instance%20as%20currently%20not%20on%20my%20usual%20PC.%20Had%20no%20idea%20it%20did%20not%20work%20on%202016%20-%20thanks%20a%20lot!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3461747%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3461747%22%20slang%3D%22en-US%22%3EI'm%20using%20school%20issued%20excel%202016.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3461757%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3461757%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1411950%22%20target%3D%22_blank%22%3E%40Dana_Herbin%3C%2FA%3E%26nbsp%3BSo%2C%20IFS%20won't%20work%20for%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3461768%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3461768%22%20slang%3D%22en-US%22%3EThank%20you.%20I%20tried%20to%20explain%20this%20to%20my%20teacher.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3461774%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3461774%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BShow%20this%20link%20to%20your%20teacher%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fifs-function-36329a26-37b2-467c-972b-4a39bd951d45%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fifs-function-36329a26-37b2-467c-972b-4a39bd951d45%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Silly and basic question, but why is this not working?

2022-06-02_08-07-33.jpg

 

 

6 Replies
best response confirmed by KirkExcel (Occasional Contributor)
Solution

@KirkExcel I suspect you are not on Excel 2019 or later. True?

Gosh, I do have 2019, but was using 2016 in this instance as currently not on my usual PC. Had no idea it did not work on 2016 - thanks a lot!
I'm using school issued excel 2016.

@Dana_Herbin So, IFS won't work for you.

Thank you. I tried to explain this to my teacher.