Results 1 to 7 of 7

IF with 3 possible solutions

Threaded View

jomili IF with 3 possible solutions 09-13-2010, 04:43 PM
contaminated Re: IF with 3 possible... 09-13-2010, 04:48 PM
jomili Re: IF with 3 possible... 09-13-2010, 05:02 PM
contaminated Re: IF with 3 possible... 09-13-2010, 05:04 PM
jomili Re: IF with 3 possible... 09-13-2010, 05:07 PM
romperstomper Re: IF with 3 possible... 09-13-2010, 05:39 PM
jomili Re: IF with 3 possible... 09-14-2010, 08:41 AM
  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    4,065

    IF with 3 possible solutions

    Okay, I'm having trouble with this one. Here's what I want to do:

    column A is my projection, column B is my allocation. I can't exceed my allocation, and I can't have a negative value.

    In column C I want to put my value:
    If A1 is greater than B1, I want to put B1.
    If A1 is less than zero, I want to put 0.
    If A1 is less than B1 but is equal or greater than 0 I want to put A1.

    I tried to do it with an IF formula, but couldn't figure out how to get it with 3 possible results. Can anyone advise me?

    Thanks,
    John
    Last edited by jomili; 09-14-2010 at 08:42 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