Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to create a new column on based on Percentage column

I have a table with a column that shows percentages as shown in the below image (column C), now I want to create a column on based on the percentage values in column C. For example, if the percentage...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago
    Relate to the values as decimals.
    0.01 = 1%
    0.1 = 10%
    1.0 = 100%
     
    Column = IF(Table1[Column1] > 0.1, "Wrong Data", "Correct Data")
     
Anonymous's avatar
Anonymous
Not applicable
7 years ago
Relate to the values as decimals.
0.01 = 1%
0.1 = 10%
1.0 = 100%
 
Column = IF(Table1[Column1] > 0.1, "Wrong Data", "Correct Data")
 
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous Thanks for the response.

 

Can you guide me on how to relate values as decimals?

 

Thanks!