I need to develop an "IF" statement that will check the entries across 10 columns in a single row and if the criteria is met in any of the columns, a "HT" would be entered in cell A11.
An example would be as follows:
Cells A1:A10 could contain a number 1 thru 10 depending on the row. As example could be A1=1, B1="", C1=3, D1=4, E1="", etc.
The IF criteria would be IF cell A1 or C1 or E1 contains any number, the true value would be to enter the word "HT" and the false value would be to move on to the next column or leave A11 blank once it has looked at all columns with no criteria met.
If a number existed in either A or C or E, cell A11 would be "HT" or if criteria not met, A11 would be blank.
Once the IF statement finds a column that meets the true criteria, it can stop at that point. In other words, all three columns DO NOT have to meet the criteria - only one of the three columns (A or C or E) out of the 10 total columns.
I would greatly appreciate some direction on developing this IF statement.
Thanks and have a great weekend!
Barry
An example would be as follows:
Cells A1:A10 could contain a number 1 thru 10 depending on the row. As example could be A1=1, B1="", C1=3, D1=4, E1="", etc.
The IF criteria would be IF cell A1 or C1 or E1 contains any number, the true value would be to enter the word "HT" and the false value would be to move on to the next column or leave A11 blank once it has looked at all columns with no criteria met.
If a number existed in either A or C or E, cell A11 would be "HT" or if criteria not met, A11 would be blank.
Once the IF statement finds a column that meets the true criteria, it can stop at that point. In other words, all three columns DO NOT have to meet the criteria - only one of the three columns (A or C or E) out of the 10 total columns.
I would greatly appreciate some direction on developing this IF statement.
Thanks and have a great weekend!
Barry