How do you stratify data in Excel 2000 (9.00.2720)?

A

Al Gershen

Hi group:

I'm trying to stratify cost data that is in one column into other
result columns?

For example, say the data column has five entries, such as: $1, $12,
$75, $22, and $3.

I want to stratify these costs into three result columns titled, Under
$10, Between $10 to $25, and Over $25.

What Excel formula(s) do I use to accomplish this?

Regards,
Al Gershen
Grants Pass, OR
[email protected]
 
D

Darlene Kupke

Hi group:

I'm trying to stratify cost data that is in one column into other
result columns?

For example, say the data column has five entries, such as: $1, $12,
$75, $22, and $3.

I want to stratify these costs into three result columns titled, Under
$10, Between $10 to $25, and Over $25.

What Excel formula(s) do I use to accomplish this?

Regards,
Al Gershen
Grants Pass, OR
[email protected]
Click to expand...


HI

I recommend familiarizing yourself with the IF function and AND function.
I've gone through exercises on some of the user tips recommended by these
groups. It really helps it all fall into place.

bye

Darlene
 
Top