Why the formula large return 0

%3CLINGO-SUB%20id%3D%22lingo-sub-2131146%22%20slang%3D%22en-US%22%3EWhy%20the%20formula%20large%20return%200%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2131146%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EI'm%20using%20this%20formula%26nbsp%3B%3DLARGE('Retail%20Report%20Store%20Ambassador'!EQ8%3AEQ229%3BAL6)%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22rcasquinha_0-1613202786146.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F254676i2F553A251F5A7C4E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22rcasquinha_0-1613202786146.png%22%20alt%3D%22rcasquinha_0-1613202786146.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Eit's%20showing%20that%20return%20100%25%20but%20what%20I%20get%20value%200%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20using%20this%20formula%20and%20work%20only%20in%20this%20column%20but%20the%20data%20is%20the%20same%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2131146%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2131155%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20the%20formula%20large%20return%200%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2131155%22%20slang%3D%22en-US%22%3EI%20Formatted%20the%20column%20EQ%20change%20the%20formula%20to%20values%20and%20back%20to%20formula%20and%20work%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2131172%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20the%20formula%20large%20return%200%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2131172%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F965611%22%20target%3D%22_blank%22%3E%40rcasquinha%3C%2FA%3E%26nbsp%3B!%3C%2FP%3E%3CP%3EI%20prepared%20sample%20file%20with%20sales%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20used%20some%20dynamic%20functions%20and%20drop%20down%20list.%26nbsp%3B%3C%2FP%3E%3CP%3EImplemented%20Large%20functions.%20Even%20using%20drop-down%20list%2C%20large%20function%20works%20perfectly%20depending%20selected%20number%20via%20drop-down%20list.%3C%2FP%3E%3CP%3EPlease%20note%20attached%20file%20for%20your%20further%20consideration.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20still%20you%20have%20problems%20with%20your%20file%2C%20would%20be%20better%20if%20you%20share%20your%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Ilgar_Zarbaliyev_0-1613205006903.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F254677iC075C2A88BE7747C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Ilgar_Zarbaliyev_0-1613205006903.png%22%20alt%3D%22Ilgar_Zarbaliyev_0-1613205006903.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2133002%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20the%20formula%20large%20return%200%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2133002%22%20slang%3D%22en-US%22%3EPlease%20edit%20your%20post%20%26amp%3B%20either%20share%20the%20WB%20or%20sample%20data%20with%20us%2C%2C%20and%20examine%20the%20formula%20you%20are%20trying%20so%20far!!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2133299%22%20slang%3D%22de-DE%22%3ESubject%3A%20Why%20the%20formula%20large%20return%200%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2133299%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F965611%22%20target%3D%22_blank%22%3E%40rcasquinha%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20Mr.%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F93699%22%20target%3D%22_blank%22%3ERajesh-S%20%3C%2FA%3E%20recommended%20to%20you%2C%20explain%20your%20problem%20in%20detail.%20So%20you%20can%20get%20a%20solution%20proposal%20to%20your%20problem%20much%20faster.%3C%2FP%3E%3CP%3EAt%20the%20same%20time%2C%20it%20is%20much%20easier%20for%20someone%20who%20wants%20to%20help%20understand%20the%20subject.%3C%2FP%3E%3CP%3EA%20win-win%20situation%20for%20everyone.%3C%2FP%3E%3CP%3EIt%20is%20also%20helpful%20to%20know%20the%20operating%20system%20and%20Office%2FOutlook%20version%2C%20as%20different%20approaches%20may%20be%20required%20depending%20on%20the%20Office%20version%20and%20OS.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EIf%20all%20of%20this%20is%20too%20cumbersome%20for%20you%2C%20here%20is%20some%20information%20from%20Microsoft%20about%20percentages%20that%20may%20help%20you.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EFormat%20numbers%20as%20percentages%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fformat-numbers-as-percentages-de49167b-d603-4450-bcaa-31fba6c7b6b4%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fformat-numbers-as-percentages-de49167b-d603-4450-bcaa-31fba6c7b6b4%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello

I'm using this formula =LARGE('Retail Report Store Ambassador'!EQ8:EQ229;AL6)

rcasquinha_0-1613202786146.png

it's showing that return 100% but what I get value 0

 

I'm using this formula and work only in this column but the data is the same 

5 Replies
I Formatted the column EQ change the formula to values and back to formula and work

Hi there, @rcasquinha !

I prepared sample file with sales data.

 

I used some dynamic functions and drop down list. 

Implemented Large functions. Even using drop-down list, large function works perfectly depending selected number via drop-down list.

Please note attached file for your further consideration.

 

If still you have problems with your file, would be better if you share your file.

 

Ilgar_Zarbaliyev_0-1613205006903.png

 

Please edit your post & either share the WB or sample data with us,, and examine the formula you are trying so far!!

@rcasquinha 

As Mr. Rajesh-S  recommended to you, explain your problem in detail. So you can get a solution proposal to your problem much faster.

At the same time, it is much easier for someone who wants to help to understand the subject.

A win-win situation for everyone.

It is also helpful to know the operating system and Office/Outlook version, as different approaches may be required depending on the Office version and OS.

 

If all of this is too cumbersome for you, here is some information from Microsoft about percentages that may help you.

Format numbers as percentages

https://support.microsoft.com/en-us/office/format-numbers-as-percentages-de49167b-d603-4450-bcaa-31f...

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

 

@rcasquinha 

"I Formatted the column EQ change the formula to values and back to formula and work" - still not sure why you seen the zero before. Anyway, good to know it works now.