IFS function not working

%3CLINGO-SUB%20id%3D%22lingo-sub-128192%22%20slang%3D%22en-US%22%3EIFS%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-128192%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20recently%20brought%20a%20spreadsheet%20over%20to%20a%20new%20laptop%20and%20the%20IFS%20statements%20that%20I%20had%20been%20using%20are%20no%20longer%20recognized.%20I%20get%20the%20%23NAME%3F%20error%20in%20all%20cells%20that%20are%20currently%20using%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20advise%20on%20how%20to%20fix%20this.%20Thanks.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-128192%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Desktop%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20%26amp%3B%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-252266%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-252266%22%20slang%3D%22en-US%22%3E%3CP%3Eyes%2C%20exactly%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-252224%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-252224%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20I%20figured%20it%20out%20my%20self%20after%202%20hours...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20had%20to%20switch%20the%20other%20way%20around...%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3Eifs%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E(%3C%2FSPAN%3E%3CSPAN%3EE13%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%26lt%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E-%3C%2FSPAN%3E%3CSPAN%20class%3D%22number%22%3E8%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%3EA%2417%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%3EE13%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%26lt%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E-%3C%2FSPAN%3E%3CSPAN%20class%3D%22number%22%3E6%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%3EA%2416%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%3EE13%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%26lt%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E-%3C%2FSPAN%3E%3CSPAN%20class%3D%22number%22%3E4%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%3EA%2415%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%3EE13%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%26lt%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E-%3C%2FSPAN%3E%3CSPAN%20class%3D%22number%22%3E2%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%3EA%2414%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%3EE13%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%26gt%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22number%22%3E0%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%3EA%2413%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3Estart%20from%20the%20smallest%20first%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3Eand%20it's%20working%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-252206%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-252206%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Tour%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20separate%20topic%2C%20better%20to%20start%20new%20conversation%20in%20such%20case.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20for%20the%20function%2C%20IFS%20works%20till%20first%20TRUE%20condition.%20If%20E13%20is%20-10%20it's%20definitely%20less%20than%20-2.5%2C%20condition%20TRUE%20and%20formula%20returns%204%2F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-252203%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-252203%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Jim%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EReplace%20IFS%20on%20nested%20IF%20or%20wait%20for%20a%20build%20where%20IFS%20appears.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-252200%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-252200%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20help%20me%2C%20my%20IFS%20function%20is%20not%20working.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3Eifs%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E(%3C%2FSPAN%3EE13%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%26gt%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22number%22%3E0%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20string%20%22%3E%225%22%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3EE13%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%26lt%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E-%3C%2FSPAN%3E%3CSPAN%20class%3D%22number%22%3E2.5%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20string%20%22%3E%224%22%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3EE13%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%26lt%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E-%3C%2FSPAN%3E%3CSPAN%20class%3D%22number%22%3E5%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20string%20%22%3E%223%22%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3EE13%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%26lt%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E-%3C%2FSPAN%3E%3CSPAN%20class%3D%22number%22%3E7.5%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20string%20%22%3E%222%22%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20class%3D%22boolean%22%3Etrue%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20string%20%22%3E%221%22%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E)%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3Ewhy%20do%20i%20always%20get's%20a%20%3CSTRONG%3E4%3C%2FSTRONG%3E%20result%20%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-252044%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-252044%22%20slang%3D%22en-US%22%3EOur%20IT%20team%20switch%20me%20from%20office%20365%20to%20excel%20pro%202016%20and%20I%E2%80%99m%20having%20these%20problems%20with%20existing%20spreadsheet%20that%20have%20IFS%20formulas.%20What%20can%20I%20do%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-241453%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-241453%22%20slang%3D%22en-US%22%3E%3CP%3EFred%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYour%20initial%20formula%20looks%20like%20this%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20225px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F44726iC98591F73F6FF5F4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EWhat%20I%20actually%20did%20that's%20click%20on%20formula%20bar%2C%20IFs%20is%20converted%20to%20IFS%20and%20returns%20result.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20211px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F44727iF379CD13AB8854CD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIf%20in%20addition%20press%20Enter%20correct%20formula%20will%20be%20populated%20on%20entire%20column.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENot%20sure%20why%20that%20happens%2C%20formulas%20are%20not%20case%20sensitive%20and%20column%20is%20formatted%20as%20General.%20But%20I%20did%20that%20on%20Windows%20desktop.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-241252%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-241252%22%20slang%3D%22en-US%22%3E%3CP%3EThanks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20checked%20and%20the%20excel%20sheet%20shows%20the%20result%20of%20the%20formula%20you%20inputted.%20I%20copied%20and%20passed%20your%20formula%20into%20a%20larger%20version%20of%20the%20excel%20sheet%20I%20was%20using%2C%20but%20it%20came%20up%20with%20the%20same%20%23NAME%20error.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-240579%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-240579%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Fred%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECould%20you%20please%20check%20if%20attached%20works%20on%20your%20computer.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-239943%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-239943%22%20slang%3D%22en-US%22%3EHello%20Haytham%2C%3CBR%20%2F%3EThanks.%3CBR%20%2F%3EI%20work%20for%20an%20S%26amp%3BP%20500%20company%2C%20and%20our%20Office%20365%20subscription%20comes%20included%20in%20our%20devices(including%20SharePoint%20online).%20When%20working%20remotely%20I%20check%20my%20work%20mails%2Foutlook%20through%20office%20365%20online.%20My%20Excel%20comes%20as%20part%20of%20the%20office%20subscription%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-239926%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-239926%22%20slang%3D%22en-US%22%3E%3CP%3EFred%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20seems%20that%20you%20have%20no%20Office%20365%20subscription%20as%20I%20don't%20see%20anything%20in%20About%20Excel%20Form%20indicates%20that%20you%20have%20an%26nbsp%3BOffice%20365%20subscription.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-239864%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-239864%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20attached%20the%20sample%20file%20from%20a%20tutorial%20i%20am%20learning.%20Please%20see%20column%20F%20(Age%20Group).%20I%20have%20also%20included%20a%20screen%20grab%20showing%20details%20of%20my%20Excel%20version%20and%20the%20excel%20sheet%20showing%20the%20error.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F44480iFFECEAB99DE5DAF4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22screen-grab.jpg%22%20title%3D%22screen-grab.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-239595%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-239595%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Fred%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20Excel%20team%20says%20that%20this%20function%20is%20now%20available%20in%20the%20latest%20update%20to%20Excel%20for%20Mac%20(version%2016.x).%3C%2FP%3E%3CP%3EPlease%20read%20this%20%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304933-excel-for-mac%2Fsuggestions%2F14450448-add-recent-excel-windows-functions-to-mac-version%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eannouncement%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20make%20sure%20you%20have%20the%20latest%20Excel%20update%20and%20verify%20your%20Office%20365%20subscription.%3CSPAN%20class%3D%22%22%3E%3CBR%20%2F%3EIf%20the%20problem%20still%20exists%3C%2FSPAN%3E%2C%20please%20send%20feedback%20to%20Microsoft%20or%20ask%20this%20%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ecommunity%3C%2FA%3E%20as%20it's%20the%20best%20place%20to%20get%20support.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-239564%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-239564%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20general%20shall%20work%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20598px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F44430i25E6D5FD4656DF3A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EPerhaps%20some%20other%20reason.%20If%20you%20attach%20sample%20file%20we%20may%20check%20if%20it%20works%20on%20other%20platform.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-239442%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-239442%22%20slang%3D%22en-US%22%3EHello%20Haytham%2C%3CBR%20%2F%3EI%20am%20using%20office%20365%20(through%20my%20office%20MAC%20laptop)%20and%20also%20having%20the%20same%20error.%20I%20am%20using%20Excel%20version%2016.16.1%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-128363%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-128363%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Aaron%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIFS%20function%20is%26nbsp%3Bonly%20available%20for%20Office%20365%20subscribers%2C%20it%20came%20to%20Excel%20with%20January%26nbsp%3B2016%20updates%20for%20Office%20365.%20Follow%20the%20below%20link%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FIFS-function-36329a26-37b2-467c-972b-4a39bd951d45%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EIFS%20Function%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMake%20sure%20that%20you%20have%20Office%20365%20subscription%20with%20version%201601%20(Build%206568.2025)%20and%20above!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20have%20in%20your%20new%20laptop%20an%20earlier%20version%20of%20Excel%20or%20Excel%202016%20as%20a%20one-time%20purchase%2C%26nbsp%3Bit%20is%20normal%20to%20see%20the%20%3CSTRONG%3E%23NAME%3F%3C%2FSTRONG%3E%20instead%20of%20%3CSTRONG%3EIFS%3C%2FSTRONG%3E%20function%2C%20because%20it's%20not%20defined%20in%20these%20versions%20of%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-775850%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-775850%22%20slang%3D%22en-US%22%3E%3CP%3EIFS%20does%20not%20work%20in%20my%20Excel%202016%20even%20though%20the%20help%20page%20says%20it%20does.%26nbsp%3B%20It%20is%20not%20listed%20in%20the%20functions.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-775869%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-775869%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382933%22%20target%3D%22_blank%22%3E%40ApolloJFK%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESupport%20page%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fifs-function-36329a26-37b2-467c-972b-4a39bd951d45%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fifs-function-36329a26-37b2-467c-972b-4a39bd951d45%3C%2FA%3Esays%20it's%20for%20Office%20365%20subscribers%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-775896%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-775896%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E.%26nbsp%3B%20I%20just%20installed%20the%20Office%20365%20version%20and%20now%20it%20works.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-776063%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776063%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382933%22%20target%3D%22_blank%22%3E%40ApolloJFK%3C%2FA%3E%26nbsp%3B%2C%20okay%2C%20good%20to%20know%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1127081%22%20slang%3D%22en-US%22%3EIFS%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1127081%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20experts%2C%20I%20have%20a%20subscription%20of%20Office%20365%20(in%20fact%20my%20employer%20has).%20I%20am%20working%20on%20a%20database%20using%20the%20IFS%20function.%20Everything%20works%20well%2C%20I%20save%20the%20work%20and%20set%20the%20file%20aside.%20After%20a%20while%2C%20if%20I%20reopen%20the%20file%2C%20the%20formula%20with%20the%20IFS%20function%20is%20substituted%20with%20%22%3D_xlfn.IFS((LEFT(%5B%40FR%5D%2C3)%3D%22101%22)...%22.%3C%2FP%3E%3CP%3EWhen%20the%20sheet%20updates%20the%20values%2C%20then%20the%20formula%20is%20not%20recognised%2C%20and%20if%20I%20re-write%20the%20initial%20formula%20(that%20is%20%22%3DIFS((LEFT(%5B%40FR%5D%2C3)%3D%22101%22)...%22)%20the%20formula%20is%20not%20recognised%20either.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%26nbsp%3Bproblem%20arose%20several%20times.%20I%20am%20not%20sure%20how%20I%20fixed%20it.%20Maybe%20I%20closed%20excel%2C%20or%20restarted%20the%20computer.%20What%20is%20sure%20is%20that%20it%20keeps%20occurring.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20table%20I%20am%20using%20is%20of%20about%205200%20lines%20and%20the%20file%20size%20is%20about%207MB.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20also%20syncing%20the%20files%20with%20onedrive.%3C%2FP%3E%3CP%3EIn%20the%20past%20this%20syncing%20function%20caused%20me%20enormous%20problems%20as%20instead%20of%20updating%20the%20new%20files%20I%20worked%20on%2C%20the%20syncing%20kept%20downloading%20and%20substituting%20the%20new%20with%20previous%20versions%20-%20yet%20this%20is%20another%20annoying%20problem.%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20assistance.%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EDamiano%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1130811%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1130811%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20reply.%3C%2FP%3E%3CP%3EThe%20compute%20I%20work%20on%20initially%20had%20a%20Microsoft%20Office%20Professional%20Plus%202016%20(by%20the%20way%2C%20I%20had%20discovered%20that%20the%20release%20was%20installed%20with%20a%20pirate%20licence%20that%20the%20IT%20service%20provider%20-%20now%20sacked%20-%20had%20sold%20to%20me%20as%20authentic).%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20firm%20I%20work%20for%2C%20opted%20to%20purchase%20few%20licences%20of%20Office%20365.%20I%20installed%20one%20of%20the%20licences%20and%20everything%20worked%20well%20for%20a%20while.%3C%2FP%3E%3CP%3ELast%20week%2C%20after%20writing%20on%20this%20forum%2C%20I%20checked%20and%20for%20some%20reason%20it%20appeared%20that%20the%20version%20installed%20is%20MSOffice%20Professional%20Plus%202016.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20switch%20licence%2C%20but%20I%20did%20not%20work.%20I%20tried%20something%20more%20drastic%3A%26nbsp%3BI%20uninstalled%20everything%20(MSOffice%20and%20all%20other%20software%20related%20to%20that%3A%20Skype%2C%20Skype%20for%20Business%2C%20OneDrive%2C%20all%20spellcheck%20plug-ins%20everything%20that%20I%20could%20recognise%20related%20to%20MSOffice)%26nbsp%3B%20and%20downloaded%20and%20installed%20Office%20365%20from%20the%20website%20over%20the%20weekend%20using%20the%20licence%20.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20process%20went%20through%20well%20and%20I%20got%20the%20message%20of%20a%20successful%20installation.%20Nevertheless%2C%20when%20checking%2C%20there%20you%20go%2C%20the%20zombie%20MSOffice%20Professional%20Plus%202016%20is%20there%20again.%3C%2FP%3E%3CP%3EWhilst%20this%20explain%20why%20IFS%20does%20not%20function%2C%20reveals%20another%20problem%3A%20I%20can't%20switch%20to%20another%20licence%20and%20I%20am%20not%20able%20to%20totally%20remove%20the%20MSOffice%20Professional%202016.%3C%2FP%3E%3CP%3EI%20am%20tempted%20to%20reinitialise%20the%20entire%20pc%2C%20but%20maybe%20you%20can%20suggest%20a%20more%20focused%2C%20less%20drastic%20solution%20to%20kill%20the%20zombie%20once%20for%20all.%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%2C%3C%2FP%3E%3CP%3EDamiano%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1128050%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1128050%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F531260%22%20target%3D%22_blank%22%3E%40DamianoStella%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECould%20you%20please%20share%20your%20current%20Excel%20version%20which%20is%20File-%26gt%3BAbout%20and%20looks%20like%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20532px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F167105iB36F193BCB7E9D36%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello,

 

I recently brought a spreadsheet over to a new laptop and the IFS statements that I had been using are no longer recognized. I get the #NAME? error in all cells that are currently using them.

 

Please advise on how to fix this. Thanks. 

35 Replies
Highlighted

@ApolloJFK , okay, good to know

Highlighted

Hi experts, I have a subscription of Office 365 (in fact my employer has). I am working on a database using the IFS function. Everything works well, I save the work and set the file aside. After a while, if I reopen the file, the formula with the IFS function is substituted with "=_xlfn.IFS((LEFT([@FR],3)="101")...".

When the sheet updates the values, then the formula is not recognised, and if I re-write the initial formula (that is "=IFS((LEFT([@FR],3)="101")...") the formula is not recognised either. 

 

This problem arose several times. I am not sure how I fixed it. Maybe I closed excel, or restarted the computer. What is sure is that it keeps occurring. 

The table I am using is of about 5200 lines and the file size is about 7MB. 

I am also syncing the files with onedrive.

In the past this syncing function caused me enormous problems as instead of updating the new files I worked on, the syncing kept downloading and substituting the new with previous versions - yet this is another annoying problem.

Thank you for your assistance.

Regards,

Damiano

Highlighted

@DamianoStella 

Could you please share your current Excel version which is File->About and looks like

image.png

Highlighted

@Sergei Baklan 

Thank you for your reply.

The compute I work on initially had a Microsoft Office Professional Plus 2016 (by the way, I had discovered that the release was installed with a pirate licence that the IT service provider - now sacked - had sold to me as authentic). 

The firm I work for, opted to purchase few licences of Office 365. I installed one of the licences and everything worked well for a while.

Last week, after writing on this forum, I checked and for some reason it appeared that the version installed is MSOffice Professional Plus 2016. 

I tried to switch licence, but I did not work. I tried something more drastic: I uninstalled everything (MSOffice and all other software related to that: Skype, Skype for Business, OneDrive, all spellcheck plug-ins everything that I could recognise related to MSOffice)  and downloaded and installed Office 365 from the website over the weekend using the licence . 

The process went through well and I got the message of a successful installation. Nevertheless, when checking, there you go, the zombie MSOffice Professional Plus 2016 is there again.

Whilst this explain why IFS does not function, reveals another problem: I can't switch to another licence and I am not able to totally remove the MSOffice Professional 2016.

I am tempted to reinitialise the entire pc, but maybe you can suggest a more focused, less drastic solution to kill the zombie once for all. 

thank you,

Damiano

@DamianoStella 

You may try complete uninstall, that's option 2 here https://support.office.com/en-us/article/uninstall-office-from-a-pc-9dd49b83-264a-477a-8fcc-2fdf5dbf.... Uninstalling from Control Panel keeps some elements of the Office. 

Highlighted

@Sergei Baklan 

Thx, I'll try right away. I'll keep you posted.

cheers

Highlighted

@Sergei Baklan 

Thx, it worked. I had to run the Microsoft Support and Recovery Assistant a couple of time, and i succeded to remove the previous installation download the new and install it.

Now IFS works and a new "@" operator appeared in some formula.

best,

damiano

Highlighted

@DamianoStella , great, glad to know you sorted this out

Highlighted

@Sergei Baklan 

 

Hi Sir,

can you help me with this ifs error

 

=ifs(BG8>"7:00","LT",BG8>"19:00","LT",BG8<"7:00","P",BG8>"19:00","P")

 

  #NAME? 
    
    
 01-Oct02-Oct03-Oct
RestdayThursdayFridaySaturday
Monday6:146:126:39

 

Thanks

Highlighted
Hi sir,
can you help me with this ifs formula error,
=ifs(BG8>"7:00","LT",BG8>"19:00","LT",BG8<"7:00","P",BG8>"19:00","P")
Highlighted

@Wipsupervisor 

That could be

=IFS( (BG8>7/24)*(BG8<19/24),"LT",TRUE,"P")

or

=IF( (BG8>=7/24)*(BG8<=19/24),"LT","P")

 

In Excel datetime is actually the number their date is integer part and time is decimal one. In days calculation one day is equal to 1, thus one hour is 1/24.

Highlighted

 

@Sergei Baklan 

 

Thanks for your response,

 

but seems the formula was not meet the condition

 
 
 15:00        
 #NAME?=_xlfn.IFS( (BG8>7/24)*(BG8<19/24),"LT",TRUE,"P")   
 LT=IF( (BG8>=7/24)*(BG8<=19/24),"LT","P")    
          
Highlighted
I think IFs is not supported on my excel work sheet
Highlighted

@Wipsupervisor 

Yes, it's not supported. For such case simple IF() is even easier.

Highlighted
i want this kind of formula.

When time is
>7=LT
<7=P
>19=LT
<19=P

Thanks

Highlighted

@Wipsupervisor 

Sorry, I didn't catch the logic. Let say your time is 10. It's >7 (thus LT), but at the same time it's <19 (thus P). What shall be taken?