Results 1 to 5 of 5

Formula to Test if Value is 0 or More

Threaded View

  1. #1
    Registered User
    Join Date
    02-21-2020
    Location
    LOS ANGELES
    MS-Off Ver
    WINDOWS 10
    Posts
    1

    Formula to Test if Value is 0 or More

    how can I write a formula to do this:

    If A1-A10 is 0 or greater, add 1, if blank leave blank. Something like this: =IF(A1:A10>=0, "ADD 1", "LEAVE BLANK"

    For example:

    # A B
    1 0 1
    2
    3 7 8
    5
    6
    7 10 11
    8
    9 11 12
    9
    10 15 16

    THANK YOU IN ADVANCE FOR YOUR HELP!
    Last edited by AliGW; 02-22-2020 at 03:01 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 04-11-2019, 03:15 AM
  2. Creating. Excel Formula
    By tgukltd in forum Excel General
    Replies: 2
    Last Post: 06-22-2018, 08:54 PM
  3. I Need Help Creating a Complex Formula in Excel
    By hamilton_00 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-11-2015, 08:44 AM
  4. need help with creating formula in excel
    By gauravi in forum Excel General
    Replies: 1
    Last Post: 01-25-2007, 06:32 AM
  5. [SOLVED] Need help on creating a formula in excel
    By tbarrows in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-25-2006, 12:35 AM
  6. Creating an Excel Formula
    By clark1269 in forum Excel General
    Replies: 1
    Last Post: 07-23-2006, 07:10 PM
  7. Creating a formula in excel
    By lissasusan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-10-2006, 05:15 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