Frequency formula

[SilviaDDSh130]

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.

[#2 · Accepted 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%?

[#3]

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