Results 1 to 7 of 7

Nested IF statement

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-24-2011
    Location
    Los Angeles, CA
    MS-Off Ver
    Office 2010
    Posts
    164

    Nested IF statement

    Hi All,
    Any help would be greatly appreciated. Using Excel 2003.
    I'm having problems with my formula for Column M.

    My formula is: =IF(AND(K9>0,L9>0),L9,J9)

    What I'm trying to do is:
    1) if Col K is > $0.00, then Col M would be equal to Col L -- This works with my formula
    2) if Col L is =<$0.00 then Col M would be equal to Col J -- Not with this formula!


    This is wanted results:Col H Col I Col J Col K Col L Col M
    EOM-Totals EOM-Diff Accrual Reversal
    R8 $0.00 $33,957.62 $33,957.62 $8,837.96 $25,119.66 $25,119.66
    R9 $0.00 $28,169.60 $28,169.60 $0.00 $28,169.60 $0.00
    R10 $0.00 $19,237.74 $19,237.74 $25,000.00 -$5,762.26 $19,237.74

    $25,119.66
    Results I'm getting $28,169.60
    $19,237.74

    Clearly, I'm using the wrong formula or need to nest and or if or another and statement inside, however everything I've been trying doesn't work. Any help would greatly appreciated. file attached
    Attached Files Attached Files
    Last edited by Delta729; 04-02-2011 at 12:48 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