Home

funzione SE

%3CLINGO-SUB%20id%3D%22lingo-sub-876261%22%20slang%3D%22en-US%22%3Efunzione%20SE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-876261%22%20slang%3D%22en-US%22%3E%3CP%3Ecome%20imporre%20un%20vincolo%20di%20intervallo%3F%20per%20esempio%200%3CX%3E%26lt%3B5%20che%20scrivendolo%20in%20questo%20modo%20non%20riconosce%20la%20funzione%3C%2FX%3E%3C%2FP%3E%3CP%3Egrazie%20mille%3C%2FP%3E%3CP%3EUlisse%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-876261%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-876395%22%20slang%3D%22en-US%22%3ERe%3A%20funzione%20SE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-876395%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F415504%22%20target%3D%22_blank%22%3E%40Ulisse95%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EShould%20be%20like%20this...%3C%2FP%3E%3CP%3E%3DSE(E(x%26gt%3B0%2Cx%26lt%3B5)%2C%22Value%20if%20True%22%2C%22Value%20if%20False%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEnglish%20version%20of%20this%20formula%20would%20be%20like%20this...%3C%2FP%3E%3CP%3E%3DIF(AND(x%26gt%3B0%2Cx%26lt%3B5)%2C%22Value%20if%20True%22%2C%22Value%20if%20False%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-876410%22%20slang%3D%22en-US%22%3ERe%3A%20funzione%20SE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-876410%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20this%20solution%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Ulisse95
Occasional Visitor

come imporre un vincolo di intervallo? per esempio 0<x<5 che scrivendolo in questo modo non riconosce la funzione

grazie mille

Ulisse

1 Reply
Highlighted

@Ulisse95 

Should be like this...

=SE(E(x>0,x<5),"Value if True","Value if False")

 

English version of this formula would be like this...

=IF(AND(x>0,x<5),"Value if True","Value if False")