Forum Discussion

Nefe1930's avatar
Nefe1930
Copper Contributor
Feb 23, 2024

If statement with time.

I'm trying to have a cell that will add text based on what time it is currently. The Nested statement that I have does not put in the text.   I have A cell set to Now() I have Cell B with the valu...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 23, 2024

Nefe1930 

As variant

=IF( MEDIAN($B$1:$C$1, NOW() ) = $B$1,  "Low",
 IF( MEDIAN($B$1:$C$1, NOW() ) = NOW(), "Med",
 IF( MEDIAN($B$1:$C$1, NOW() ) = $C$1,  "High"
)))
  • Nefe1930's avatar
    Nefe1930
    Copper Contributor
    Mar 06, 2024

    SergeiBaklan 

    ok here is what is going on. The current time is 2:19pm
    The if statement is =IF( MEDIAN($D$75:$E$75, NOW() ) =$D$75, "Low",IF( MEDIAN($D$75:$E$75, NOW() ) = NOW(), "Med",IF( MEDIAN($D$75:E$75, NOW() ) = $E$75, "High")))

     

    This is what I'm getting

     

     

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Mar 06, 2024

      Nefe1930 

      Try

       

      =LET(t, MOD(NOW(),1), IF(t<D75, "Low", IF(t>E75, "High", "Med")))

      • roelofknol's avatar
        roelofknol
        Copper Contributor
        Oct 31, 2024
        I was struggling with this too. Your statement worked and solved my problem.
        Just so that I understand things properly for next time: does the part of the formula LET(t, MOD(NOW(),1) convert the current time into a number value/format for the IF statement to compare against as opposed to being a date/time format?

Resources