Results 1 to 2 of 2

Thread: Formula calculation with a max value

  1. #1

    Formula calculation with a max value



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I'm adding two cells together and multiplying by 3(=sum(a1:b1)*3), but I don't want the total to exceed 15. Is there a way to do this? Below is an example of what I'm doing.

    Cell A1 has a value of 5 and cell B1 has a value of 12. I want to subtract cell A1(5) from cell B1(12), then multiply times 3.
    =sum(a1:b1)*3
    This will give me a value of 21, but I need the maximum value to be 15.

    Can someone please help!!

    Thanks

  2. #2
    Acolyte Canapone's Avatar
    Join Date
    Oct 2011
    Location
    Italy
    Posts
    97
    Articles
    0
    Excel Version
    Excel 2010
    Hi,

    you could use MIN,

    If you need to sum A1 and B1

    =MIN((A1+B1)*3,15)

    If you'd need a subtraction instead

    =MIN((B1-A1)*3,15)

    Hope it helps

Posting Permissions

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