I
iachuan
Hi,
I have nine columns say column A to column I and each of them contain
some data and I have another column called "Code".
If column A is not empty ( even though the other column contain data)
then code=A
If column A is empty but column A is not empty then Code=B
......and so on.
For cells empty in column A through column I, I use Code"excluded"
I use formula
=IF((A2<>""),"A",IF((b2<>""),"B",IF((c2<>""),"C",IF((d2<>""),"D",if((e2<>""),"E",if((f2<>""),"F",If((g2<>""),"G",if((h<>""),"H",
if((i2<>""),"i","excluded")))))))))
But I found I can't have over 7 multiple ifs.
Can anyone give me a advice? How to fix my formula?
I have nine columns say column A to column I and each of them contain
some data and I have another column called "Code".
If column A is not empty ( even though the other column contain data)
then code=A
If column A is empty but column A is not empty then Code=B
......and so on.
For cells empty in column A through column I, I use Code"excluded"
I use formula
=IF((A2<>""),"A",IF((b2<>""),"B",IF((c2<>""),"C",IF((d2<>""),"D",if((e2<>""),"E",if((f2<>""),"F",If((g2<>""),"G",if((h<>""),"H",
if((i2<>""),"i","excluded")))))))))
But I found I can't have over 7 multiple ifs.
Can anyone give me a advice? How to fix my formula?