Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding a max percentage to existing formula
I have the following example where the second column calculates 10% for every age. But when I get to an age over 5, I want the formula to only calculate a maximum percentage of 50%. How do I add this to my current formula?
Age Value 1 =(0.1*D6)*J6 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding a max percentage to existing formula
Hi,
Am Fri, 16 Dec 2016 16:45:03 +0000 schrieb JedSrq: I have the following example where the second column calculates 10% for every age. But when I get to an age over 5, I want the formula to only calculate a maximum percentage of 50%. How do I add this to my current formula? Age Value 1 =(0.1*D6)*J6 try: =MIN(0.1*D6,0.5)*J6 Regards Claus B. -- Windows10 Office 2016 |
#3
|
|||
|
|||
Quote:
Thanks! You are the bomb!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding in an 'IF' to existing formula | Excel Discussion (Misc queries) | |||
Formula for multiplying and adding percentage please help. | New Users to Excel | |||
How to calculate a percentage formula with existing data? | Excel Worksheet Functions | |||
Adding to an existing formula | Excel Worksheet Functions | |||
adding formula to existing database | Excel Worksheet Functions |