Forum Discussion
Calculated Column with IF / OR
Hi, I need a calculated column to compare the values in two other columns and IF either of them are true, return True (Yes), if not return False (No). I have the below but im obviously going wron...
Barking_Mad you've put the result into single quotes which is why you are getting the error, it should be:
=IF(OR(Fruit="Banana",Fruit="Apple"),"True","False")
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)