View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default 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