Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
how to return a date between two cells | Excel Discussion (Misc queries) | |||
How do I lookup two cells and return a third. | Excel Worksheet Functions | |||
Function to look at two cells and return a third | Excel Worksheet Functions | |||
Return non-zero cells in column | Excel Worksheet Functions |