IFS Formula help needed

Question

Hello&nbsp;I am trying to write (withut success) a formula to say if Column 1 = same as column B = TRUE, or if column 1 = Oliveand column B = Olives, TRUE (ie contains "Olive"), if not FALSE&nbsp;The table below shows the output i want but I'm struggle with the IF formula&nbsp;Please Help!&nbsp;AppleAppleTRUEOlivesOliveTRUEOlivesBlueberryFALSEOlivesOlivesTRUEOrangeBananaFALSE

sgeorgie · Answer

SGeorgie&nbsp;Any assistance would be great&nbsp;ThanksSarah&nbsp;

Forum Discussion

IFS Formula help needed

Share

Resources

Apple	Apple	TRUE
Olives	Olive	TRUE
Olives	Blueberry	FALSE
Olives	Olives	TRUE
Orange	Banana	FALSE