Forum Discussion

FranckGbadamass's avatar
FranckGbadamass
Icon for Helper I rankHelper I
4 years ago
Solved

M formula explanation

Hello community,   I'm stucked with M formula:   My formula doesn't return what I expected:   if [Hours] = {8,8.5,9,9.5,10,10.5,11,11.5} then "morning" else if [Hours] = {18,18.5,19,19.5} then ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi FranckGbadamass ,

     

    Try this:

    if [Hours] >= 8 and [Hours] <= 11.5 then "morning"
else if [Hours] >= 18 and [Hours] <= 19.5 then "night"
else "none"

     

    Pete

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
4 years ago

Hi FranckGbadamass ,

 

Try this:

if [Hours] >= 8 and [Hours] <= 11.5 then "morning"
else if [Hours] >= 18 and [Hours] <= 19.5 then "night"
else "none"

 

Pete