+ Reply to Thread
Results 1 to 2 of 2

Need help using IF statements to ignore the first row, then follow through with the math

  1. #1
    Registered User
    Join Date
    06-18-2014
    Location
    Collierville, TN
    MS-Off Ver
    2013
    Posts
    1

    Need help using IF statements to ignore the first row, then follow through with the math

    I'm trying to set up a ledger essentially to keep track of purchases and sales.

    What I have in mind is in A1 to be the total cash, set up to add the value of the action based on if the action is declared a buy or sell.

    A2 would say "Action" with the rest of the column from A3 onto forever, saying "buy" or "sell"

    Column B would have the value of the action


    How can I set up A1 to show a dollar amount that adds what's in B for "sell" and subtracts B for "buy".


    I currently have A1=IF(A:A="buy",-B:B,IF(A:A="sell", +B:B)). However, this causes an error.

    Any help would be greatly appreciated, ahead of time.

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Need help using IF statements to ignore the first row, then follow through with the ma

    Can you use a sumIFs instead? Can you post a sample datase so we can see what you are doing?
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. If statements and math function..
    By christopherL in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-14-2013, 09:01 AM
  2. Replies: 12
    Last Post: 07-04-2013, 07:26 AM
  3. Using furthest down Cell for math statements
    By ssword in forum Excel General
    Replies: 19
    Last Post: 11-03-2010, 04:31 PM
  4. Replies: 12
    Last Post: 05-15-2009, 08:38 AM
  5. Replies: 3
    Last Post: 02-16-2006, 07:00 AM

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