LinkBack URL
About LinkBacks
Hi All,
I am trying to get the following AND OR formula right...Can you please help here..
=IF(OR(AND(K2=1,M2!=' '),AND(L2=1,M2! = ' ')),1,0)
Thanks,
Arn
And or formula
Hi All,
I am trying to get the following AND OR formula right...Can you please help here..
=IF(OR(AND(K2=1,M2!=' '),AND(L2=1,M2! = ' ')),1,0)
Thanks,
Arn
You need to use <> for 'not equal to', instead of !=
And you need to use " " instead of ' ' to surround string values.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Thanks Olly !..Appreciate your response!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks