dual logical IF formula

[mkyb14]

Looking for some help in how to setup a logical IF statement (believe that's the right terminology).

Column C below, I'm trying to determine the following

• G1 = if network count =0 & Device count is >1000 - Then fill in G1 into cooresponding C cell
• G2 = if network count >1 & device count =0 - Then fill in G2 into corresponding C Cell

I have one massive sheet with columns A and B filled out, I'd like to automate logic to fill in C by group type defined above

Data:

Column A = Network count, Column B=Device Connections Count, Column C=Group formula (G1,G2)

A | B | C
1 | 14 | blank
0 | 2000 | G1
1 | 0 | G2

 

[AhoyNC]

Try:
In your example above the 3 row would be blank since 1 is not greater than 1.

Excel Workbook
	A	B	C	D	E	F	G
1	1	14					Test1
2	0	2000	Test1				Test2
3	2	0	Test2
Sheet

 

[mkyb14]

Thank you for the help. How do you account for cells that don't have a 0 and are blank? in the B3=0, really is b3=""

Try:
In your example above the 3 row would be blank since 1 is not greater than 1.

	A	B	C	D	E	F	G

<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]14[/TD]

[TD="align: center"]Test1[/TD]

[TD="align: center"]2[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]2000[/TD]
[TD="align: center"]Test1[/TD]

[TD="align: center"]Test2[/TD]

[TD="align: center"]3[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]Test2[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula C1 =IF(AND(A1=0,B1>1000),$G$1,IF(AND(A1>1,B1=0),$G$2,"")) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[AhoyNC]

You mean like this?

Excel Workbook
	A	B	C	D	E	F	G
1	1	14					Test1
2	0	2000	Test1				Test2
3	2
Sheet