[IF Function] Question about values

[iSuw]

Hi there,

I have a question about the IF Function in Excel 2007. I currently have a spreadsheet that's separated into categories, in specific by "Departments". Here's an example:

[Column A]
[1] Deparment=1209
[2] Food
[3] Water
[4] Clothes
[5] Misc
[6] Department=1211
[7] Housing
[8] Transportation
[9] Utlities
[10]Security

What I'm trying to do is insert a new "Column A" and have the Department number for each item listed there. So, Rows 1-5 of Column A would each say "Department=1209", and Rows 6-10 of Column A would each say "(Department=1211)". I did this a couple of weeks ago using the IF command, but I can't remember the values I inserted.

Could anyone help on this? Thank you!

 

[VoG]

Try this

Excel Workbook
	A	B
1	Department=1209	Department=1209
2	Department=1209	Food
3	Department=1209	Water
4	Department=1209	Clothes
5	Department=1209	Misc
6	Department=1211	Department=1211
7	Department=1211	Housing
8	Department=1211	Transportation
9	Department=1211	Utlities
10	Department=1211	Security
Sheet1

 

[iSuw]

Worked perfectly. Thank you so so much!