SOLVED

Frequency formula

%3CLINGO-SUB%20id%3D%22lingo-sub-3350364%22%20slang%3D%22en-US%22%3EFrequency%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3350364%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20help%20me%20with%20setting%20up%20a%20right%20formula%20in%20excel%3F%20I%20am%20wondering%20why%20when%20I%20type%20the%26nbsp%3B%20frequency%20formula%20bellow%2C%20it%20shows%3A%200%2C%200%2C%204%20and%20not%202%2C%201%2C%201%2C%20would%20appreciate%20if%20someone%20can%20help.%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%22SilviaDDSh130_0-1652184513676.jpeg%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370455i1436BCC9EEE0A728%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22SilviaDDSh130_0-1652184513676.jpeg%22%20alt%3D%22SilviaDDSh130_0-1652184513676.jpeg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3350364%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-3350457%22%20slang%3D%22en-US%22%3ERe%3A%20Frequency%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3350457%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1385855%22%20target%3D%22_blank%22%3E%40SilviaDDSh130%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMake%20sure%20that%20D5%20and%20D6%20are%20numbers%2C%20and%20not%20text%20values%20that%20look%20like%20numbers.%3C%2FP%3E%0A%3CP%3EWhat%20happens%20if%20you%20clear%20D5%20and%20D6%2C%20format%20those%20cells%20as%20a%20percentage%2C%20then%20enter%2010%25%20and%2050%25%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3350743%22%20slang%3D%22en-US%22%3ERe%3A%20Frequency%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3350743%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much%2C%20it%20worked!%20It%20turned%20out%20that%20the%20ratio%20values%20were%20not%20in%20percentage%20but%20in%20other%20format.%3C%2FLINGO-BODY%3E
New Contributor

Hello, 

Can someone help me with setting up a right formula in excel? I am wondering why when I type the  frequency formula bellow, it shows: 0, 0, 4 and not 2, 1, 1, would appreciate if someone can help.

 

SilviaDDSh130_0-1652184513676.jpeg

 

2 Replies
best response confirmed by SilviaDDSh130 (New Contributor)
Solution

@SilviaDDSh130 

Make sure that D5 and D6 are numbers, and not text values that look like numbers.

What happens if you clear D5 and D6, format those cells as a percentage, then enter 10% and 50%?

Thank you so much, it worked! It turned out that the ratio values were not in percentage but in other format.