multiple if statemenrt

Question

i have a column DOD wich is true/false/null and a column DATE which is filled or blanki have the following statementsFORMULA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DOD column&nbsp; &nbsp; &nbsp; &nbsp;DATE column&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RESULT COLUMNIF DOD IS TRUE AND DATE IS FILLED = 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TRUE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/1/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1IF DOD IS TRUE AND DATE IS BLANK = 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TRUE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BLANK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2IF DOD IS FALSE AND DATE IS FILLED =3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FALSE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1/1/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3IF DOD IS FALSE AND DATE IS BLANK =4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FALSE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BLANK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4IF DOD IS BLANK AND DATE IS BLANK = 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BLANK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BLANK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5

anonymous · Accepted Answer

Hi,&nbsp;Framboosje1&nbsp;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&nbsp;Best,&nbsp;Paul

Forum Discussion

multiple if statemenrt

1 Reply

Related content

MULTIPLE CARD

Multiple dataViewMappings

Merge data from multiple excel files from multiple sharepoint folders

Disable multiple eventstreams

IF, Multiple