Forum Discussion

miltenburger's avatar
miltenburger
Icon for Helper V rankHelper 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 Geca...
Need Help
anandraman's avatar
anandraman
Icon for Helper I rankHelper 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
Icon for Helper V rankHelper V
8 years ago

Thanks anandraman

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