Frequency and If with multiple Columns

Jym

Junior Member

Posts: 2

Actually it's "<" the right column and "=" the left column so 49.9 is an F and 50 is a D-

Quote:

Originally Posted by T. Valko

One problem you have is that your boudaries overlap:

0 50 F
50 52 D-
52 56 D
56 59 D+

Is a score of 50 a F or a D- ?

--
Biff
Microsoft Excel MVP

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
FREQUENCY across multiple worksheets	Fin Fang Foom	Excel Worksheet Functions	0	September 25th 07 03:04 PM
Combine multiple columns into two long columns, Repeating rows in first column	[email protected]	Excel Discussion (Misc queries)	2	July 31st 06 09:45 PM
Combine multiple columns into two long columns, Repeating rows in first column	[email protected]	Excel Discussion (Misc queries)	0	July 31st 06 05:07 PM
histograms - frequency and relative frequency?	confusedstudent	Excel Discussion (Misc queries)	2	February 8th 06 08:20 AM
how do get the frequency in 2 columns	Hi	Excel Worksheet Functions	0	December 9th 05 02:55 PM

All times are GMT +1. The time now is 12:43 AM.

About Us