If statement

[eramirez148]

How can I get the results in column b. if an entry in column A is higher than 30% then my return should be 30%

Column A	Column B
38%	30%
18%	18%
23%	23%
50%	30%
55%	30%
60%	30%
80%	30%
90%	30%
10%	10%

 

[Joe4]

For a value in cell A2, use this formula:

=MIN(A2,30%)

and format as a percent.