Nesting formula help!

[04_launder_spirals]

Hello! I need to nest a formula to return the word True or turn the statement to True if the cell is blank. This is what I have so far =IF(A2="A",B2="Apple",IF(A2="B",B2="Bat",IF(A2="A",B2="",IF(A2="B",B2="", TRUE)))) but it is returning False for the cell that are blank. I have attached a workbook. Please help!

 

[Luke M]

Rather than trying to understand your method, what's the goal? To check if value in col A is the first letter of col B?

=AND(A2<>"",LEFT(B2)=A2)

 

[04_launder_spirals]

Rather than trying to understand your method, what's the goal? To check if value in col A is the first letter of col B?

=AND(A2<>"",LEFT(B2)=A2)

The method is to also return TRUE on Column C when Column B is blank. Your formula and mine are both returning False. I can't show the original file since I am working on a template provided by the employer. Can an ISNA formula be added to return the word TRUE when thee cell B is blank?

 

[S P P]

LAUNDER
=IF(AND(A2="";B2="");"";IF(OR(A2="";B2="");"";IF(AND(A2="A";B2="Apple");TRUE;IF(AND(A2="B";B2="Bat");TRUE;FALSE))))

 

[04_launder_spirals]

LAUNDER
=IF(AND(A2="";B2="");"";IF(OR(A2="";B2="");"";IF(AND(A2="A";B2="Apple");TRUE;IF(AND(A2="B";B2="Bat");TRUE;FALSE))))

Thank you! I am getting the "Not trying to type this formula, =you type: = =1=1, cell, etc message. Any idea where is the error?

 

[S P P]

look at this

 

[04_launder_spirals]

look at this

Thank you!