Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create a calculated column from a percent column

Hi all,  I need a formula please to create a column from another column, Here'is my excel formula : =IFS(Q2=0%,"DRAFT",(AND(Q2>0%,Q2<100%)),"IN PROGRESS",Q2=100%,"CLOSED") I tried this formula on ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    HI  Anonymous 

    Just adjust the the formula as below:

    Status =
IF (
    'DATA'[Progress] = 0,
    "DRAFT",
    IF (
        'DATA'[Progress] < 1
            && 'DATA'[Progress] > 0,
        "IN PROGRESS",
        IF ( 'DATA'[Progress] = 1, "CLOSED" )
    )
)

     

     

    Regards,

    Lin

     

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
6 years ago

HI  Anonymous 

Just adjust the the formula as below:

Status =
IF (
    'DATA'[Progress] = 0,
    "DRAFT",
    IF (
        'DATA'[Progress] < 1
            && 'DATA'[Progress] > 0,
        "IN PROGRESS",
        IF ( 'DATA'[Progress] = 1, "CLOSED" )
    )
)

 

 

Regards,

Lin