Home

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%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%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%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%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-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
Aaron Fitzgerald
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. 

22 Replies

Dear Aaron,

 

IFS function is only available for Office 365 subscribers, it came to Excel with January 2016 updates for Office 365. Follow the below link:

IFS Function

 

Make sure that you have Office 365 subscription with version 1601 (Build 6568.2025) and above!

 

If you have in your new laptop an earlier version of Excel or Excel 2016 as a one-time purchase, it is normal to see the #NAME? instead of IFS function, because it's not defined in these versions of Excel.

 

Hello Haytham,
I am using office 365 (through my office MAC laptop) and also having the same error. I am using Excel version 16.16.1

In general shall work

image.png

Perhaps some other reason. If you attach sample file we may check if it works on other platform.

Hi Fred,

 

The Excel team says that this function is now available in the latest update to Excel for Mac (version 16.x).

Please read this announcement.

 

Please make sure you have the latest Excel update and verify your Office 365 subscription.
If the problem still exists
, please send feedback to Microsoft or ask this community as it's the best place to get support.

 

Hope that helps

I have attached the sample file from a tutorial i am learning. Please see column F (Age Group). I have also included a screen grab showing details of my Excel version and the excel sheet showing the error.screen-grab.jpg

Fred,

 

It seems that you have no Office 365 subscription as I don't see anything in About Excel Form indicates that you have an Office 365 subscription.

Highlighted
Hello Haytham,
Thanks.
I work for an S&P 500 company, and our Office 365 subscription comes included in our devices(including SharePoint online). When working remotely I check my work mails/outlook through office 365 online. My Excel comes as part of the office subscription

Hi Fred,

 

Could you please check if attached works on your computer.

Thanks.

 

I have checked and the excel sheet shows the result of the formula you inputted. I copied and passed your formula into a larger version of the excel sheet I was using, but it came up with the same #NAME error.

Fred,

 

Your initial formula looks like this

image.png

What I actually did that's click on formula bar, IFs is converted to IFS and returns result.

image.png

If in addition press Enter correct formula will be populated on entire column.

 

Not sure why that happens, formulas are not case sensitive and column is formatted as General. But I did that on Windows desktop.

 

Our IT team switch me from office 365 to excel pro 2016 and I’m having these problems with existing spreadsheet that have IFS formulas. What can I do

Please help me, my IFS function is not working. 

 

=ifs(E13>0,"5",E13<-2.5,"4",E13<-5,"3",E13<-7.5,"2",true,"1")

 

why do i always get's a 4 result ?

Hi Jim,

 

Replace IFS on nested IF or wait for a build where IFS appears.

Hi Tour,

 

That's separate topic, better to start new conversation in such case.

 

As for the function, IFS works till first TRUE condition. If E13 is -10 it's definitely less than -2.5, condition TRUE and formula returns 4/

Hey I figured it out my self after 2 hours...

 

I've had to switch the other way around...

=ifs(E13<-8,A$17,E13<-6,A$16,E13<-4,A$15,E13<-2,A$14,E13>0,A$13)

start from the smallest first

 

and it's working

 

yes, exactly

IFS does not work in my Excel 2016 even though the help page says it does.  It is not listed in the functions.

Thank you @Sergei Baklan .  I just installed the Office 365 version and now it works.

@ApolloJFK , okay, good to know

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

@DamianoStella 

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

image.png

Related Conversations
Which formula to use
Ramon Haagen in Excel on
2 Replies
function talking to table storage
donquijote in Compute on
0 Replies
Calculated column help
gopalaraoa in SharePoint on
1 Replies
Combining IF and INDEX functions
Hans van Deursen in Windows PowerShell on
2 Replies
Finding the data and to color code it
NishantSalunkhe in Excel on
3 Replies