Forum Discussion

AllanBerces's avatar
AllanBerces
Icon for Post Prodigy rankPost Prodigy
10 months ago
Solved

Multiple If

Hi good day can anyone help me on my calculated column with multiple if. - IF % Complete is equal to 0 then Estimate hrs - IF % Complete is equal to 100 then Actual hrs - IF % Complete is greatert...
Need Help
  • qqqqqwwwweeerrr's avatar
    qqqqqwwwweeerrr
    10 months ago

    Hi AllanBerces , 

     

    Here is my solution: 

    Final Hours =
    VAR Pct = Sheet1[% Complete]
    VAR Est = Sheet1[Estimate hrs]
    VAR Act = Sheet1[Actual hrs]
    RETURN
        SWITCH(
            TRUE(),
            -- 1. If Estimate is blank : use Actual
            ISBLANK(Est), Act,

            -- 2. If % Complete = 0 : Estimate hrs
            Pct = 0, Est,

            -- 3. If % Complete = 100 :  Actual hrs
            Pct = 100, Act,

            -- 4. If % Complete > 75 : Actual hrs
            Pct > 75, Act,

            -- 5. If % Complete < 75 :  pick higher of Estimate vs Actual
            Pct < 75, MAX(Est, Act)
        )

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
    Check for more intersing solution here: www.youtube.com/@Howtosolveprobem

    Regards

qqqqqwwwweeerrr's avatar
qqqqqwwwweeerrr
Icon for Solution Sage rankSolution Sage
10 months ago

Hi AllanBerces , 

 

Here is my solution: 

Final Hours =
VAR Pct = Sheet1[% Complete]
VAR Est = Sheet1[Estimate hrs]
VAR Act = Sheet1[Actual hrs]
RETURN
    SWITCH(
        TRUE(),
        -- 1. If Estimate is blank : use Actual
        ISBLANK(Est), Act,

        -- 2. If % Complete = 0 : Estimate hrs
        Pct = 0, Est,

        -- 3. If % Complete = 100 :  Actual hrs
        Pct = 100, Act,

        -- 4. If % Complete > 75 : Actual hrs
        Pct > 75, Act,

        -- 5. If % Complete < 75 :  pick higher of Estimate vs Actual
        Pct < 75, MAX(Est, Act)
    )

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: www.youtube.com/@Howtosolveprobem

Regards

  • AllanBerces's avatar
    AllanBerces
    Icon for Post Prodigy rankPost Prodigy
    10 months ago

    Hi qqqqqwwwweeerrr thank you very much for the reply work as i need