Forum Discussion

Framboosje1's avatar
Framboosje1
Frequent Visitor
6 years ago
Solved

multiple if statemenrt

i have a column DOD wich is true/false/null and a column DATE which is filled or blank i have the following statements FORMULA                                                            DOD column ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi, Framboosje1 


    You can create a column useing SWITCH in side a SWITCH, first you read DOD then check where DATE is bland. This formula should be clear.

    Result =
SWITCH (
    [DOD],
    TRUE (), SWITCH ( [DATE], BLANK (), 2, 1 ),
    FALSE (), SWITCH ( [DATE], BLANK (), 4, 3 ),
    BLANK (), 5

     

    Best, 
    Paul

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi, Framboosje1 


You can create a column useing SWITCH in side a SWITCH, first you read DOD then check where DATE is bland. This formula should be clear.

Result =
SWITCH (
    [DOD],
    TRUE (), SWITCH ( [DATE], BLANK (), 2, 1 ),
    FALSE (), SWITCH ( [DATE], BLANK (), 4, 3 ),
    BLANK (), 5

 

Best, 
Paul