Results 1 to 6 of 6

Addition with strange condition

This is a discussion on Addition with strange condition within the Excel Questions forums, part of the Question Forums category; Hi, Formula in cell A2 is a simple (=A1+1), so that where: content of cell A1 is 98 cell A2 ...

  1. #1
    Board Regular
    Join Date
    Jun 2002
    Location
    Toronto,Canada
    Posts
    59

    Default Addition with strange condition

    Hi,

    Formula in cell A2 is a simple (=A1+1), so that where:

    content of cell A1 is 98
    cell A2 would add 1 and show 99

    content of cell A1 is 99
    cell A2 would add 1 and show 100

    However where content of cell A1 surpasses 100:

    I DO NOT wish A2 to add 1 but instead to continue to display 100.

    Where cell A1 is 99 or less cell A2 will add 1 as normal, upto
    a maximum of 100.

    If what I'm after is not clear, I apologise and will elaborate.
    Thanks for your assistance.
    SEMME

  2. #2
    MrExcel MVP, Administrator Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686

    Default Re: Addition with strange condition

    Maybe something like this?

    =IF(A1+1>=100,100,A1+1)
    Kristy

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,948

    Default Re: Addition with strange condition

    Or

    =MIN(100, A1+1)
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  4. #4
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690

    Default Re: Addition with strange condition

    OR
    =MIN(A1+1,100)

    Edit; **** , I'm slow Juan

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654

    Default Re: Addition with strange condition

    =MIN(A1+1,100)

  6. #6
    Board Regular
    Join Date
    Jun 2002
    Location
    Toronto,Canada
    Posts
    59

    Default Re: Addition with strange condition

    Thanks Again for your support,

    The MIN function worked well for my purpose.

    SEMME

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com