Forum Discussion

miltenburger's avatar
miltenburger
Helper V
8 years ago

Help with IF statement

Hi people,

 

I need some help with my if statement. 

I need a new column based on following statements (see picture for three different columns right now)* 

 

* "G" = Aantal geboekt <= Uren Gecalculeerd

* "O" = Aantal geboekt <= Uren Gecalculeerd + Uren Risico Opslag & > Uren Gecalculeerd + Uren Risico Opslag

* "R" = Aantal gebpekt > Uren Gecalculeerd + Uren Risico Opslag

 

 

Hope you guys can help me out, thanks in advance

 

Kind regards Miltenburger

 

Need Help

9 Replies

  • anandraman's avatar
    anandraman
    Helper I
    8 years ago

    TryTry this:

     

    =IF( Aantal geboekt <= Uren Gecalculeerd ,"G",
    IF(Aantal geboekt <= Uren Gecalculeerd + Uren Risico Opslag && Aantal geboekt > Uren Gecalculeerd + Uren Risico Opslag , "O",
    IF(Aantal gebpekt > Uren Gecalculeerd + Uren Risico Opslag,"R")))

    • miltenburger's avatar
      miltenburger
      Helper V
      8 years ago

      Thanks anandraman

      I thought this was the solution, but it seems that there are still some wrong calculations in it

       

      • miltenburger's avatar
        miltenburger
        Helper V
        8 years ago

        In addition to this, to orange one doesn't seems te work