Excel 2002: How to identify row of data ?
Hi,
Happy New Year to you. I have the following table: A B C D E Total Type 1 0 -100 0 +100 0 0 B 2 0 0 0 0 0 0 A 3 0 0 0 0 0 0 A 4 -500 0 +500 0 -750 +750 B I would like to assign row type as "A" when all the cells from column A to E are 0, otherwise it is type "B" I find that the formula I am using now is too long i.e. =IF(AND(A1=0,B1=0,C1=0,D1=0,E1=0),"A","B"). Are there any shorter formulas ? Thanks Low |
Excel 2002: How to identify row of data ?
Hi,
Maybe this =IF(COUNTIF(A1:E1,0)=5,"A","B") Mike "Mr. Low" wrote: Hi, Happy New Year to you. I have the following table: A B C D E Total Type 1 0 -100 0 +100 0 0 B 2 0 0 0 0 0 0 A 3 0 0 0 0 0 0 A 4 -500 0 +500 0 -750 +750 B I would like to assign row type as "A" when all the cells from column A to E are 0, otherwise it is type "B" I find that the formula I am using now is too long i.e. =IF(AND(A1=0,B1=0,C1=0,D1=0,E1=0),"A","B"). Are there any shorter formulas ? Thanks Low |
Excel 2002: How to identify row of data ?
This is for A thru Z:
=IF(COUNTIF(A1:Z1,"<0")=0,"A","B") -- Gary''s Student - gsnu200909 "Mr. Low" wrote: Hi, Happy New Year to you. I have the following table: A B C D E Total Type 1 0 -100 0 +100 0 0 B 2 0 0 0 0 0 0 A 3 0 0 0 0 0 0 A 4 -500 0 +500 0 -750 +750 B I would like to assign row type as "A" when all the cells from column A to E are 0, otherwise it is type "B" I find that the formula I am using now is too long i.e. =IF(AND(A1=0,B1=0,C1=0,D1=0,E1=0),"A","B"). Are there any shorter formulas ? Thanks Low |
Excel 2002: How to identify row of data ?
Hello Mike,
Thanks for the formulka. Low "Mike H" wrote: Hi, Maybe this =IF(COUNTIF(A1:E1,0)=5,"A","B") Mike "Mr. Low" wrote: Hi, Happy New Year to you. I have the following table: A B C D E Total Type 1 0 -100 0 +100 0 0 B 2 0 0 0 0 0 0 A 3 0 0 0 0 0 0 A 4 -500 0 +500 0 -750 +750 B I would like to assign row type as "A" when all the cells from column A to E are 0, otherwise it is type "B" I find that the formula I am using now is too long i.e. =IF(AND(A1=0,B1=0,C1=0,D1=0,E1=0),"A","B"). Are there any shorter formulas ? Thanks Low |
Excel 2002: How to identify row of data ?
Hi Gary's Student,
Thanks for the formulka. Low "Gary''s Student" wrote: This is for A thru Z: =IF(COUNTIF(A1:Z1,"<0")=0,"A","B") -- Gary''s Student - gsnu200909 "Mr. Low" wrote: Hi, Happy New Year to you. I have the following table: A B C D E Total Type 1 0 -100 0 +100 0 0 B 2 0 0 0 0 0 0 A 3 0 0 0 0 0 0 A 4 -500 0 +500 0 -750 +750 B I would like to assign row type as "A" when all the cells from column A to E are 0, otherwise it is type "B" I find that the formula I am using now is too long i.e. =IF(AND(A1=0,B1=0,C1=0,D1=0,E1=0),"A","B"). Are there any shorter formulas ? Thanks Low |
All times are GMT +1. The time now is 12:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com