Results 1 to 4 of 4

formula to limit maximum value

Threaded View

  1. #1
    Registered User
    Join Date
    06-13-2011
    Location
    Boston
    MS-Off Ver
    Excel 2003
    Posts
    2

    formula to limit maximum value

    hi guys,

    i have a simple spreadsheet where i'm totalling a few values thru a formula. it's similar to this:

    =D13*F13

    i'm trying to create a funcion that says if d13 * f13 >= 300, i want the value to stay at 300 max and at the same time, if d13 * f13 < 300, i want the total to remain whatever it is.

    i have been able to create both of these formulas successfully by themselves but i can't combine them. is this possible?

    any help would be greatly appreciated!!
    Last edited by tomco11ins; 06-14-2011 at 08:31 PM.

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