If function

%3CLINGO-SUB%20id%3D%22lingo-sub-1601062%22%20slang%3D%22en-US%22%3EIf%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1601062%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20when%20I%20try%20the%20formula%20from%20your%20homepage%20(%3D%2Bif(F8%26gt%3B89%3B%22A%22%3BF8%26gt%3B79%3B%22B%22%3BF8%26gt%3B69%3B%22C%22%3BF8%26gt%3B59%3B%22D%22%3Btrue%3B%22F%22)%20I%20get%20then%20NAME%3F%20Can%20you%20help%20me%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1601062%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1601117%22%20slang%3D%22en-US%22%3ERe%3A%20If%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1601117%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F765578%22%20target%3D%22_blank%22%3E%40CRP-19751415%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20formula%20logical%20test%20incorrect%2C%20could%20you%20please%20attach%20the%20sample%20file%20with%20few%20data%20and%20your%20desired%20result%20to%20advise%20you%20the%20correct%20solution.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1601195%22%20slang%3D%22en-US%22%3ERe%3A%20If%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1601195%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F765578%22%20target%3D%22_blank%22%3E%40CRP-19751415%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20looks%20like%20you%20mean%20IFS%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIFS(F8%26gt%3B89%3B%22A%22%3BF8%26gt%3B79%3B%22B%22%3BF8%26gt%3B69%3B%22C%22%3BF8%26gt%3B59%3B%22D%22%3Btrue%3B%22F%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1601222%22%20slang%3D%22en-US%22%3ERe%3A%20If%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1601222%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%3BThanks%20that%20was%20what%20I%20was%20looking%20for%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%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1601231%22%20slang%3D%22en-US%22%3ERe%3A%20If%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1601231%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F765578%22%20target%3D%22_blank%22%3E%40CRP-19751415%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi when I try the formula from your homepage (=+if(F8>89;"A";F8>79;"B";F8>69;"C";F8>59;"D";true;"F") I get then NAME? Can you help me?

4 Replies

Hi @CRP-19751415

 

Your formula logical test incorrect, could you please attach the sample file with few data and your desired result to advise you the correct solution.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more

@CRP-19751415 

It looks like you mean IFS

=IFS(F8>89;"A";F8>79;"B";F8>69;"C";F8>59;"D";true;"F")

@Sergei Baklan Thanks that was what I was looking for

@CRP-19751415 , you are welcome