Excel problem

%3CLINGO-SUB%20id%3D%22lingo-sub-1271219%22%20slang%3D%22en-US%22%3EExcel%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1271219%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%3C%2FP%3E%3CP%3EI%20have%20a%20problem%20with%20making%20this%20apply%20all%20result%20that%20i%20have%20coded%20in.%20This%20one%20is%20writen%20in%20norwegian.%3C%2FP%3E%3CP%3E%3DHVIS.SETT(OG(J13%3D%22Gdansk%22%3BK13%3D%22Norfolk%22)%3BB8%3BOG(J13%3D%22Gdansk%22%3BK13%3D%22Jacksonville%22)%3BC8%3BOG(J13%3D%22Gdansk%22%3BK13%3D%22New%20Orleans%22)%3BD8)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DSUMIFS(AND(J13%3D%22Gdansk%22%3BK13%3D%22Norfolk%22)%3BB8%3BAND(J13%3D%22Gdansk%22%3BK13%3D%22Jacksonville%22)%3BC8%3BAND(J13%3D%22Gdansk%22%3BK13%3D%22New%20Orleans%22)%3BD8)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20partial%20gives%20me%20the%20soulotions.%20It%20gives%20me%20the%20results%20for%20B8%20and%20C8%2C%20but%20not%20D8.%20Why%20is%20that%20happening%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%20Vinni%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1271219%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1271697%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1271697%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F604376%22%20target%3D%22_blank%22%3E%40Vinni420%3C%2FA%3E%26nbsp%3BTook%20your%20Norwegian%20formula.%20Translated%20it%20to%20English%20and%20it%20seems%20to%20work%20as%20you%20expect%20it%20to.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DIFS(AND(J13%3D%22Gdansk%22%2CK13%3D%22Norfolk%22)%2CB8%2CAND(J13%3D%22Gdansk%22%2CK13%3D%22Jacksonville%22)%2CC8%2CAND(J13%3D%22Gdansk%22%2CK13%3D%22New%20Orleans%22)%2CD8)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETranslated%20back%20to%20Norwegian%20it's%20like%20this%2C%20exactly%20the%20same%20as%20you%20original%20formula.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DHVIS.SETT(OG(J13%3D%22Gdansk%22%3BK13%3D%22Norfolk%22)%3BB8%3BOG(J13%3D%22Gdansk%22%3BK13%3D%22Jacksonville%22)%3BC8%3BOG(J13%3D%22Gdansk%22%3BK13%3D%22New%20Orleans%22)%3BD8)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EAttached%20a%20file%20with%20a%20working%20formula.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi.

I have a problem with making this apply all result that i have coded in. This one is writen in norwegian.

=HVIS.SETT(OG(J13="Gdansk";K13="Norfolk");B8;OG(J13="Gdansk";K13="Jacksonville");C8;OG(J13="Gdansk";K13="New Orleans");D8)

 

=SUMIFS(AND(J13="Gdansk";K13="Norfolk");B8;AND(J13="Gdansk";K13="Jacksonville");C8;AND(J13="Gdansk";K13="New Orleans");D8)

 

It partial gives me the soulotions. It gives me the results for B8 and C8, but not D8. Why is that happening?

 

Regards Vinni

1 Reply
Highlighted

@Vinni420 Took your Norwegian formula. Translated it to English and it seems to work as you expect it to.

=IFS(AND(J13="Gdansk",K13="Norfolk"),B8,AND(J13="Gdansk",K13="Jacksonville"),C8,AND(J13="Gdansk",K13="New Orleans"),D8)

 

Translated back to Norwegian it's like this, exactly the same as you original formula.

=HVIS.SETT(OG(J13="Gdansk";K13="Norfolk");B8;OG(J13="Gdansk";K13="Jacksonville");C8;OG(J13="Gdansk";K13="New Orleans");D8)

Attached a file with a working formula.