Results 1 to 7 of 7

Need help with a formula

Threaded View

  1. #1
    Registered User
    Join Date
    11-30-2012
    Location
    little rock, ar
    MS-Off Ver
    excel 2007
    Posts
    3

    Formula calculation with a max value

    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
    Last edited by bryanp21; 11-30-2012 at 05:08 AM.

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1