CODEWITHSUNDEEP
sharepoint
AlHal
AlHal

Reputation: 397

sharepoint list validation with multiple operators

I have a SharePoint list with two numeric fields Sunday and Monday and a currency field rate per job. I want to validate the list, so that the rate per job is greater than zero. I also want to check that either Sunday or Monday is greater than zero. How do I do this using the AND and OR operators? This is what I tried.

=OR(=AND([RatePerJob]>0,[RatePerJob]<50),([Sun]>0 , [Mon]>0))

I'm using SharePoint Online.

Upvotes: 0

Views: 307

Answers (1)

Michael Han
Michael Han

Reputation: 3655

Try the below :

=AND(AND([RatePerJob]>0,[RatePerJob]<50),OR([Sun]>0 , [Mon]>0))

Upvotes: 1

Related Questions