1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel 97 formula

Discussion in 'Business Applications' started by Fergus76, Jun 6, 2001.

Thread Status:
Not open for further replies.
  1. Fergus76

    Fergus76 Thread Starter

    Joined:
    Feb 13, 2001
    Messages:
    5
    I have a list of figures, inlcuding minus figures and I am having difficulty coming up with a formula to do what I want to do. What I want is to have a formula, which checks a column of figures "A" and if an amount is 0 or negative, then put the amount in a new column, "B".

    Thanks in advance.
     
  2. Gram123

    Gram123

    Joined:
    Mar 15, 2001
    Messages:
    1,829
    Hi Fergus,

    In Column B (cell B1 in this example), type:

    =IF(A1<=0,A1,"")

    The double quotes is just to ensure nothing is written to cell B1 if A1 is above zero.


    HTH

    Gram
     
  3. Fergus76

    Fergus76 Thread Starter

    Joined:
    Feb 13, 2001
    Messages:
    5
    Thanks! I'll give it a try!
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/45547

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice