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
|