Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
Just a quick one if have an if statement where there are 3 potential right answers (4,5 or 6). What is the correct syntax for 'OR' statements?
if(Month([Pickup Date])=('4,5,6'),Sum(Pop2016)+Sum([Peak Tourist Pop])
Any help would be appreciated.
Cheers,
Chris
May be using Match
=If(Match(Month([Pickup Date]), 4, 5, 6), Sum(Pop2016) + Sum([Peak Tourist Pop]))
Hi there,
If(Month([Pickup Date] >=4 and Month([Pickup Date] <=6, Sum(Pop2016)+Sum([Peak Tourist Pop]) as ...
Regards,
Hi Sunny,
This doesn't seem to be working although I don't know why the logic seems sound