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

  • Thread starter Thread starter Al Gershen
  • Start date Start date
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
(e-mail address removed)
 
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
(e-mail address removed)
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
 
Back
Top