Home

Formulas apparently working don't pass for some options

%3CLINGO-SUB%20id%3D%22lingo-sub-764808%22%20slang%3D%22en-US%22%3EFormulas%20apparently%20working%20don't%20pass%20for%20some%20options%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-764808%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHello%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20have%20an%20issue%20with%20my%20Excel%20file.%20I%20have%20some%20boards%20linked%20by%20formulas.%20Normally%20I%20checked%20more%20than%202%20times%2C%20it%20should%20be%20ok.%20But%20some%20boxes%20don't%20fill%20as%20they%20should.%20Would%20you%20have%20an%20advice%3F%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20give%20you%20the%20file%2C%20it%20is%20for%20the%20tabb%20%2207.19%22%2C%20where%20the%20totals%20of%20the%20lines%20with%20the%20red%20indicator%20should%20appear%20in%20the%20board%20down%20right.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks%20a%20lot%20!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-764808%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-765081%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20apparently%20working%20don't%20pass%20for%20some%20options%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-765081%22%20slang%3D%22en-US%22%3EFormulas%20are%20working%20properly.%20If%20there%20is%20a%20result%20you%20think%20is%20wrong%2C%20please%20tell%20us%20which%20one.%20Most%20likely%20you're%20seeing%20a%20value%20with%20a%20format%20applied%20and%20it%20looks%20wrong%20to%20you%2C%20but%20the%20underlying%20value%20is%20calculated%20correctly.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-767068%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20apparently%20working%20don't%20pass%20for%20some%20options%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-767068%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F19137%22%20target%3D%22_blank%22%3E%40Zack%20Barresse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20having%20%26nbsp%3Blook!%3C%2FP%3E%3CP%3EFew%20cells%20are%20wrong%2C%20for%20example%3A%20in%20tab%20'07.19'%2C%20the%20combinaison%20C11-D11-E11%20corresponds%20to%20the%20cells%26nbsp%3B%3C%2FP%3E%3CP%3EN136-O136-P136.%20The%20total%20in%20K11%20should%20appear%20in%20Q136%2C%20but%20it%20doesn't....%20I%20can't%20get%20why%20!%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20a%20lot%20for%20your%20help%20!%3C%2FP%3E%3CP%3EAuriane%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-767180%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20apparently%20working%20don't%20pass%20for%20some%20options%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-767180%22%20slang%3D%22en-US%22%3E%3CP%3EI%20finally%20got%20it%20solved%2C%20it%20was%20a%20problem%20of%20format!%3C%2FP%3E%3CP%3EThanks%20again%20for%20your%20attention%3C%2FP%3E%3C%2FLINGO-BODY%3E
auriane78
Occasional Contributor

Hello,

 

I have an issue with my Excel file. I have some boards linked by formulas. Normally I checked more than 2 times, it should be ok. But some boxes don't fill as they should. Would you have an advice? 

 

I give you the file, it is for the tabb "07.19", where the totals of the lines with the red indicator should appear in the board down right.

 

Thanks a lot !

3 Replies
Formulas are working properly. If there is a result you think is wrong, please tell us which one. Most likely you're seeing a value with a format applied and it looks wrong to you, but the underlying value is calculated correctly.

@Zack Barresse 

 

Hi, 

 

Thank you for having  look!

Few cells are wrong, for example: in tab '07.19', the combinaison C11-D11-E11 corresponds to the cells 

N136-O136-P136. The total in K11 should appear in Q136, but it doesn't.... I can't get why !?

 

Thanks a lot for your help !

Auriane

I finally got it solved, it was a problem of format!

Thanks again for your attention

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies