IF EXACT Formula with multiple chains

[boojooo]

Hello,

I am attempting to do an IF/EXACT formula that contains two different values. Here is the formula that I've come up with, but it keeps returning a #N/A value:

=IF(EXACT(G2,"B"),"Btl"),IF(EXACT(G2,"b"),"btl","")

 

[tyija1995]

It is to do with your parenthesis; you closed it after "Btl" (Before the 2nd IF statement)

Try:
=IF(EXACT(G2,"B"),"Btl",IF(EXACT(G2,"b"),"btl",""))

 

[Special-K99]

IF(condition, value if true, value if false)

Your second IF will never be executed since it's not part of the first IF

It should be

=IF(EXACT(G2,"B"),"Btl",IF(EXACT(G2,"b"),"btl",""))

 

[boojooo]

Thank you tyija1995 and special-k99, you're both right and that's exactly what I was look for!

 

[njimack]

I see you now have a solution, but there are numerous ways of solving this which don't use as many nested function, e.g

=IF(UPPER(G2)="B",G2&"tl","")