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.
    This will give me a value of 21, but I need the maximum value to be 15.

    Can someone please help!!


  2. #2
    Acolyte Canapone's Avatar
    Join Date
    Oct 2011
    Excel Version
    Excel 2010

    you could use MIN,

    If you need to sum A1 and B1


    If you'd need a subtraction instead


    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