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
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies