Percentage max formula?

[liaper]

i need to find out how divide two cells but the answer cannot be more than 150%
for example: I want to divide A2 and A1 abd have the answer be on A3 but the
percentage in A3 can not be higher than 150%
A
1 1
2 3
3 300.00%

 

[Niek Otten]

=MIN(A2/A1,1.5)

Format as %

 

[tompl]

This formula should give you the lesser of the calculated % and 150%:

=MIN(A2/A1,1.5)

Tom