Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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% |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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% |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentage max formula?
This formula should give you the lesser of the calculated % and 150%:
=MIN(A2/A1,1.5) Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
percentage formula | Excel Discussion (Misc queries) | |||
Percentage formula | Excel Discussion (Misc queries) | |||
Percentage Formula | Excel Worksheet Functions | |||
Percentage Formula Help | Excel Worksheet Functions | |||
I need a percentage Formula | Excel Discussion (Misc queries) |