+ Reply to Thread
Results 1 to 5 of 5

if WITH 3 CRITERIA

  1. #1
    Registered User
    Join Date
    08-31-2012
    Location
    Boston
    MS-Off Ver
    Excel 2007
    Posts
    14

    if WITH 3 CRITERIA

    HI

    i want to express in a column based on criteria in another column

    column N has a currency amount
    i want to populate column O based on that number:

    if column N has a positive amount populate in column o "1"
    if column N has a o amount populate in column o "o"
    if column N has a negative amount populate in column o "credit"

    I have

    =IF(OFFSET (N2;0;-1)>O ; "1" ; IF(OFFSET (N2;0;-1)=0; "0" ; "CREDIT" ) )

    but am not getting the output i expect - actually am getting an error

    i can do the following successfully:

    =IF(N2 >0, 1, 0)

    which will give me the "0" or "1" for >0 or <=0
    but am having trouble adding the condition for a negative number

    thanks!

    scuba2x2

  2. #2
    Registered User
    Join Date
    10-27-2012
    Location
    London
    MS-Off Ver
    Excel 2007-2010
    Posts
    59

    Re: if WITH 3 CRITERIA

    Hey Scuba2x2,

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Your logic in your formula looks correct though, but formula above works also.

  3. #3
    Registered User
    Join Date
    08-31-2012
    Location
    Boston
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: if WITH 3 CRITERIA

    thanks
    I got what I was looking for with

    =IF($N$2>0,"1",IF($N$2=0,"0","CREDIT"))

    but i simply cannot fig out how to delete a POST

    I know its under edit but where?

    can anybody assist with that?

    thanks!

    S2x2

  4. #4
    Registered User
    Join Date
    10-27-2012
    Location
    London
    MS-Off Ver
    Excel 2007-2010
    Posts
    59

    Re: if WITH 3 CRITERIA

    Just mark your post as solved.

    By the way the formula you have in your last post has cell N2 as anchored so if you drag it down your formula will always be looking at N2.

  5. #5
    Registered User
    Join Date
    08-31-2012
    Location
    Boston
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: if WITH 3 CRITERIA

    THANKS very much!
    (ya I realized I had a ref to update)

    not seeing where to mark the post as solved..
    im assuming its edit/...
    sorry, its just not really obvious if you haven't seen it before

    is there a way to delete - say, i posted a duplicate?

    -
    S22

+ Reply to Thread

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