5 Replies Latest reply: May 15, 2014 10:07 AM by Data Kruncher RSS

    Can we do nested if?????

    Set_Shot _

      Any reason why this nested if statement didn't work

       

      If(Inst=1,"01",if(Inst=2,"02",if(Inst=4,"04"))) and I tried this if(Inst=1,01,if(Inst=2,02,if(inst=4,04)))

       

      thanks in advance:confused: