IF plus AND nested multiple times

[Tommeck37]

Hello,

Can anyone help me find what is the problem with the following formula?
I searched the forum and could not find anything like that.

=IF(AND(G2="1",H2="C"),"CREDIT CORR"),IF(AND(G2="0",H2="C"),"DEBIT CORR")

I receive

[TABLE="width: 126"]
<tbody>[TR]
[TD="width: 126, align: center"]#VALUE![/TD]
[/TR]
</tbody>[/TABLE]

thanks for any hints

regards
Tommeck37

 

[JackDanIce]

Your formula has a closing bracket in the wrong place and a missing FALSE outcome. I also suspect, G2 contains the number one rather than the character "1", check the cell formatting, depending on whether it's General, Number, Text or something else.

Try:

=IF(AND(G2=1,H2="C"),"CREDIT CORR",IF(AND(G2=0,H2="C"),"DEBIT CORR", "Something Else"))

 

[Tommeck37]

Hello,

Thank you very much. This solved my issue. Though the numbers in this formula are texts. All I did only was to change bracket positions.

thank you again!

Tommeck37

 

[JackDanIce]

Cool, glad it's resolved