View Single Post
  #1   Report Post  
JedSrq JedSrq is offline
Junior Member
 
Posts: 2
Default 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