Forum Discussion

Krijgersss's avatar
Krijgersss
Icon for Helper II rankHelper II
2 years ago
Solved

if statement with percentage

i need some help with my if statement how can i make it that it wil get my percentage range  Kolom = IF([% Uren begroot] > "80%" && [% Uren begroot] <= "100%", filter ( operation implementatie))...
Need Help
  • BiAnalyst's avatar
    BiAnalyst
    2 years ago

    you pretty much have it correct.

     

    try following,


    Kolom =
    IF(
    [% Uren begroot] > 0.8 && [% Uren begroot] <= 1,
    "Operation Implementatie",
    BLANK()
    )

    If suggestion works, please accept it as solution.

BiAnalyst's avatar
BiAnalyst
Icon for Resolver I rankResolver I
2 years ago

you pretty much have it correct.

 

try following,


Kolom =
IF(
[% Uren begroot] > 0.8 && [% Uren begroot] <= 1,
"Operation Implementatie",
BLANK()
)

If suggestion works, please accept it as solution.