Percentage max formula?
 

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%

Percentage max formula?
 

=MIN(A2/A1,1.5)

Format as %

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"liaper" wrote in message
...
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%

Percentage max formula?
 

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

=MIN(A2/A1,1.5)

Tom