Forum Discussion
Solved
Frequency formula
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.
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%?
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.
