Remember Me?

#### Menu

#1
December 16th 16, 05:45 PM
 Junior Member First recorded activity by ExcelBanter: Dec 2016 Posts: 2
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
December 16th 16, 05:59 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Apr 2011 Posts: 3,535
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
December 16th 16, 07:06 PM
 Junior Member First recorded activity by ExcelBanter: Dec 2016 Posts: 2

Quote:
 Originally Posted by Claus Busch 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

Thanks! You are the bomb!!!

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Jim Excel Discussion (Misc queries) 3 January 28th 10 10:24 AM Johnnychadrice New Users to Excel 10 December 21st 09 07:57 PM MeaganNW Excel Worksheet Functions 4 September 8th 08 08:39 AM JPS Excel Worksheet Functions 2 April 17th 08 04:04 PM Country Boy Excel Worksheet Functions 3 September 5th 05 03:50 PM

All times are GMT +1. The time now is 10:43 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright ©2004-2017 ExcelBanter.
The comments are property of their posters.

# About Us

"It's about Microsoft Excel"

Copyright © 2017