Results 1 to 2 of 2

AP / AR Trigger for negitive numbers

Threaded View

Campbound AP / AR Trigger for negitive... 09-21-2013, 08:48 AM
FDibbins Re: AP / AR Trigger for... 09-21-2013, 04:14 PM
  1. #1
    Registered User
    Join Date
    06-25-2013
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    4

    AP / AR Trigger for negitive numbers

    Hey Gang, so I come to the experts for some advice, again.

    I have a spread sheet with many cells (A:ZZ & 10 to 40009)

    In column F, I have a drop down list giving 2 choices, AP & AR. These are the main triggers for what I need to happen.

    When I select "AP" in column F, I need column I to see only a negative number (-$100), and at the same time in column M, I need it to see only a positive number ($100)

    When I select "AR" in Column F, I need column I to see only positive number ($100), and at the same time in column N, yes N, I need it to see only a negative number (-$100)

    there are other conditions to the cells I need, but those I have figured, its this one that is stumping me.

    I have included a bit of an example with this question
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula to only add negitive numbers in selected field
    By Alexander.Tartter in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-05-2013, 12:36 PM
  2. Count only if negitive and only if positive.
    By gibbsmachine in forum Excel General
    Replies: 3
    Last Post: 12-21-2011, 09:27 AM
  3. How do I change numbers from positive to negitive
    By Debi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-11-2005, 01:09 PM
  4. Making a cell Negitive only
    By hw in forum Excel General
    Replies: 5
    Last Post: 05-24-2005, 06:32 AM
  5. [SOLVED] negitive and positive numbers
    By kematz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-02-2005, 07:06 PM

Tags for this Thread

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