Home

=MOD keeps changing to = MODE.SNGL

%3CLINGO-SUB%20id%3D%22lingo-sub-1122007%22%20slang%3D%22en-US%22%3ERe%3A%20%3DMOD%20keeps%20changing%20to%20%3D%20MODE.SNGL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1122007%22%20slang%3D%22en-US%22%3ECan%20you%20attache%20(part%20of)%20your%20file%20without%20sensitive%20data%3F%20I%20am%20unable%20to%20reporduce%20the%20problem.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1119277%22%20slang%3D%22en-US%22%3E%3DMOD%20keeps%20changing%20to%20%3D%20MODE.SNGL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1119277%22%20slang%3D%22en-US%22%3E%3CP%3EEverytime%20I%20save%20the%20file%20and%20close%20it%2C%20the%20%3DMOD%20function%20is%20changed%20to%20MODE.SNGL%20upon%20the%20next%20opening%20which%20ruins%20all%20the%20formulas%20in%20the%20sheet.%20Why%20is%20this%20happening%20and%20how%20to%20prevent%20it%3F%3C%2FP%3E%3CP%3EExact%20formula%3A%3C%2FP%3E%3CPRE%3E%3DIF(MOD(ROW()%3B8)%3D1%3BINDEKS(D%3AD%3B(ROW()%2B7)%2F8)%3B%22%22)%20%3C%2FPRE%3E%3CP%3Eformula%20that%20prints%20every%208%20cell%20value%20from%20collumn%20D%20in%20every%20cell%20in%20collumn%20A%3C%2FP%3E%3CP%3Eit%20changes%20to%3A%3C%2FP%3E%3CPRE%3E%3DIF(MODE.SNGL(ROW()%3B8)%3D1%3BINDEKS(D%3AD%3B(ROW()%2B7)%2F8)%3B%22%22)%3C%2FPRE%3E%3CP%3Enext%20time%20I%20save%20and%20re-open%20the%20file%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1119277%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
eraspirn
Occasional Visitor

Everytime I save the file and close it, the =MOD function is changed to MODE.SNGL upon the next opening which ruins all the formulas in the sheet. Why is this happening and how to prevent it?

Exact formula:

=IF(MOD(ROW();8)=1;INDEKS(D:D;(ROW()+7)/8);"") 

formula that prints every 8 cell value from collumn D in every cell in collumn A

it changes to:

=IF(MODE.SNGL(ROW();8)=1;INDEKS(D:D;(ROW()+7)/8);"")

next time I save and re-open the file

 

thank you.

1 Reply
Highlighted

Can you attach (part of) your file without sensitive data? I am unable to reporduce the problem.

Related Conversations
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies