Excel formula

[marcenet03]

Hi I need help with the following table. I'm not sure how to write the formula for the result:

My formula is : =IF(AND([@[Case Reason Reason Peanut ]]="True",[@Peanut]="False"),"True",IF([@[Share Contact ]]="False","Peanut"))

Case Reason Reason Peanut	Peanut	Share Contact	Result
False	False	FALSE​	FALSE​
True	False	TRUE​	False
False	True	FALSE​	Peanut​
True	False	False	Peanut

Would appreciate your help in advance

 

[smitpau]

Something like this might work, and just drag down the rows.

Not sure if you'd like a value for is the Sharecontact=True but could be added.

=IF(C6&D6="TrueFalse","True","Peanut")

 

[marcenet03]

Something like this might work, and just drag down the rows.

Not sure if you'd like a value for is the Sharecontact=True but could be added.

=IF(C6&D6="TrueFalse","True","Peanut")

Thank you so much. How can I add the shared contact:
=IF(AND([@[Case Reason Reason Peanut ]]&[@Peanut]="TrueFalse",[@[Share Contact ]]="False"),"False","Peanut")

 

[smitpau]

=IF(C6&D6="TrueFalse","True",IF(E6=FALSE,"FALSE","Peanut"))

For some reason Excel doesn't like the FALSE in quotation marks guess it's because it messes with the IF function logic.