Results 1 to 6 of 6

Return a value within specific parameters

Threaded View

ezdizzy Return a value within... 09-22-2009, 04:23 PM
NBVC Re: Help with a formula 09-22-2009, 04:25 PM
NBVC Re: Return a value within... 09-22-2009, 04:31 PM
Special-K Re: Return a value within... 09-22-2009, 04:36 PM
martindwilson Re: Return a value within... 09-22-2009, 04:59 PM
ezdizzy Re: Return a value within... 10-08-2009, 06:39 PM
  1. #1
    Registered User
    Join Date
    11-24-2008
    Location
    North Carolina
    MS-Off Ver
    MS365 version 2411
    Posts
    49

    Return a value within specific parameters

    Hello--

    I am looking for help with a formula for the following desired result: I have a cell with a simple formula in it. I would like to modify the contents of the cell so that if the formula itself returns a value greater than x, then the cell returns only x, and if the same formula returns a value less than 0, then the cell returns only 0. Otherwise, the cell would return whatever value the formula gives between 0 and x.

    I hope that makes sense. Thanks for any help you can provide.
    Last edited by ezdizzy; 09-22-2009 at 04:32 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