=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%