7 Replies Latest reply: Apr 19, 2016 4:21 PM by Ali Ahmad RSS

    Nested IF only work on first condition

    Ali Ahmad

      Trying to use a Variable to change sheets when a timer hits a certain amount of seconds. Written this IF statement which comes out "ok" as an expression, but only the first condition works. The 0 or 1. Not the condition for 2, 3, 4, 5 etc. Any ideas? Probably something simple I've overlooked.

       

      =

      if(vTimerSec >= 5, 1,

      if(vTimerSec >= 10, 2,
      if(vTimerSec >= 15, 3,
      if(vTimerSec >= 25, 4,
      if(vTimerSec >= 35, 5

       

      ,0)))))