IF statement with WEEKDAY() and OR()

[SharpL]

Hi Guys,

Just a quick one - I can't get the below to work when F2 is 6th May 2017 (Saturday)

=IF(WEEKDAY(ROUND(F$2,2),2)=OR(6,7),"OK","ERROR")

Thanks in advance!

[JohnTopley]

=if(or(weekday(round(f$2,2),2)=6,weekday(round(f$2,2),2)=7),"ok","error")

[shukla.ankur281190]

try

=IF(OR(WEEKDAY(ROUND(F$2,2),2)=6,WEEKDAY(ROUND(F$2,2),2)=7),"OK","ERROR")

[Phuocam]

Try this ...

=IF(WEEKDAY(ROUND(F$2,2),2)>5,"OK","ERROR")

[SharpL]

Thanks all - I guess I was using OR() incorrectly?