Can anyone help me make this formula work? I want the formula to display 1,2, or 3 depending on the time. This is the basic logic but the syntax is all wrong.
![]()
=If( =NOW() < 10:00AM, "1", if( =NOW() < 3:00PM, "2", "3"))
Can anyone help me make this formula work? I want the formula to display 1,2, or 3 depending on the time. This is the basic logic but the syntax is all wrong.
![]()
=If( =NOW() < 10:00AM, "1", if( =NOW() < 3:00PM, "2", "3"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks