chech if two or more cells = and return a value
 

Hi
dose any one know how to check if two ore more cells are true and return a
value
e.g. if a1= 10 and a2= 20 then return a value or what ever it needs to be

chech if two or more cells = and return a value
 

Use an AND, eg:
=IF(AND(A1=10,A2=20),value_if_true,value_if_false)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"nev1956" wrote:
Hi
dose any one know how to check if two ore more cells are true and return a
value
e.g. if a1= 10 and a2= 20 then return a value or what ever it needs to be

chech if two or more cells = and return a value
 

"Max" wrote:

Use an AND, eg:
=IF(AND(A1=10,A2=20),value_if_true,value_if_false)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"nev1956" wrote:
Hi
dose any one know how to check if two ore more cells are true and return a
value
e.g. if a1= 10 and a2= 20 then return a value or what ever it needs to be

chech if two or more cells = and return a value
 

"Tom" wrote
Hi there Max
I was browsing through the Microsoft Office Discussions Group and noticed
that you were able to help someone out with an Excel 2003 question similar to
what I have for you.

Here is my question:

I have a resume Excel spreadsheet in which Col. A lists the €œstates€� in
America (i.e. CA, AK, MI, ME, etc €¦) Column B states if the job position is
€œUnion€� and Column C states if the job position is €œNon Union€�. What I would
like to do is to €œCOUNT€� the number of €œUnion€� and €œNon Union€� jobs in ANY
particular state. Could you please assist me with that?. Id like to graph it
out.

Thank you and have a great day.

With sincere respect,

Tom

chech if two or more cells = and return a value
 

"Tom" wrote:

Hi there Max

I was browsing through the Microsoft Office Discussions Group and noticed
that you were able to help someone out with an Excel 2003 question similar to
what I have for you.

Here is my question:

I have a resume Excel spreadsheet in which Col. A lists the €œstates€� in
America (i.e. CA, AK, MI, ME, etc €¦) Column B states if the job position is
€œUnion€� and Column C states if the job position is €œNon Union€�. What I would
like to do is to €œCOUNT€� the number of €œUnion€� and €œNon Union€� jobs in ANY
particular state. Could you please assist me with that?. Id like to graph it
out.

Thank you and have a great day.

With sincere respect,

Tom

chech if two or more cells = and return a value
 

Think using a pivot table is quite ideal for your instance, Tom.

Assuming your data in cols A and B,
with headers in row1, eg:

States Job
CA Union
AK Non Union
MI Non Union
ME Union
CA Non Union
etc

Select cols A and B, click Data Pivot table
Click Next Next

In step 3 of the wiz, click Layout
Drag n drop States in ROW area
Drag n drop Job in COLUMN area
Drag n drop Job in DATA area
(it'll appear as Count of Job)
Click OK Finish, That's it.

Hop over to the PT sheet for the results

It'll look something like this:

Count of Job Job
States Non Union Union Grand Total
AK 2 1 3
CA 1 2 3
ME 2 1 3
MI 1 2 3
etc

viz it gives you the required unique listing of all the States,
and the breakdown counts of union/non union for each state

For charting, you could tinker by just right-clicking on any cell inside the
pivot table choose PivotChart. This would instantly yield a chart linked to
the pivot table that you can further dress up to taste.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tom" wrote:


"Tom" wrote:

Hi there Max

I was browsing through the Microsoft Office Discussions Group and noticed
that you were able to help someone out with an Excel 2003 question similar to
what I have for you.

Here is my question:

I have a resume Excel spreadsheet in which Col. A lists the €œstates€� in
America (i.e. CA, AK, MI, ME, etc €¦) Column B states if the job position is
€œUnion€� and Column C states if the job position is €œNon Union€�. What I would
like to do is to €œCOUNT€� the number of €œUnion€� and €œNon Union€� jobs in ANY
particular state. Could you please assist me with that?. Id like to graph it
out.

Thank you and have a great day.

With sincere respect,

Tom