Hi I am an absolute beginner with excel as I don't use it very often. I am having an issue with a conditional statement '=IF' that i am using o populate date from 2 different sheet in Excel 2016 and Google Sheets. The statements i have tried are:
=if(A2 = "simple", 'BB Product Build'!E2, "")
=IF(A2={"simple","variable"},'BB Product Build'!E2," ")
=IF(A2={"simple",or,"variable"},'BB Product Build'!E2," ")
The only output i get is the cell displays the formula not any results.
Please help
Solved by D. L. in 29 mins