+ Reply to Thread
Results 1 to 3 of 3

Add an increase limit to a formula

  1. 08-27-2022, 07:46 AM #1
    Marvo
    Marvo is offline
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2021
    Posts
    990

    Add an increase limit to a formula

    In the attached workbook on the sheet entitled "Master", in column BB there is a formula that works out the percentage increase to a golf handicap. What can I add to the formula to limit that increase to a maximum of 1 please?

    the formula is

    =ROUND(IF(A4=0,0,IF(AP4<$AY$3,BD4+$BB$2,0)),1)
    Attached Files Attached Files
    Last edited by Marvo; 08-27-2022 at 08:13 AM.
    Reply With QuoteRegister To Reply
  2. 08-27-2022, 08:03 AM #2
    Phuocam
    Phuocam is online now
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2021
    Posts
    5,933

    Re: Add an increase limit to a formula

    Try this

    =MIN(1,ROUND(IF(A4=0,0,IF(AP4<$AY$3,BD4+$BB$2,0)),1))
    Reply With QuoteRegister To Reply
  3. 08-27-2022, 08:13 AM #3
    Marvo
    Marvo is offline
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2021
    Posts
    990

    Re: Add an increase limit to a formula

    That's perfect, thank you very much.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. increase cell 255 limit in excel2000 help or way round it?
    By lisa in forum Excel General
    Replies: 4
    Last Post: 02-23-2023, 01:29 AM
  2. Increase character limit in a text box that is based on a formula
    By rrbest in forum Excel General
    Replies: 1
    Last Post: 11-27-2013, 04:53 PM
  3. Increase MsgBox Character Limit
    By techteam in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-13-2012, 02:38 PM
  4. Data form Limit, how to increase it?
    By mmf in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-17-2008, 11:24 AM
  5. increase cell character limit
    By Weissme in forum Excel General
    Replies: 3
    Last Post: 08-03-2006, 05:10 PM
  6. [SOLVED] Increase cell limit from 1004
    By pjbur2005 via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-16-2006, 09:13 PM
  7. [SOLVED] Is there a way to increase the AutoCorrect limit in Excel 2003?
    By RobbI in forum Excel General
    Replies: 0
    Last Post: 04-14-2006, 12:25 PM
  8. [SOLVED] Increase rows in worksheet beyond 65,536 row limit
    By Ann Calantzis in forum Excel General
    Replies: 3
    Last Post: 02-25-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1