+ Reply to Thread
Results 1 to 2 of 2

Check row for cell greater than 0

  1. #1
    Registered User
    Join Date
    12-08-2020
    Location
    Rockvill,MD
    MS-Off Ver
    2010
    Posts
    1

    Check row for cell greater than 0

    I need help with some calculation that I am trying to achieve.

    I want to create a macros or formula that will allow me to check a row of a table for values greater than 0:

    Within a row, if for all cells (that contained a number) are larger than VALUE OF 0 then output 1.

    Any help will be helpful!

    I have attached an excel file for better depiction of what I would like the result column to look like

    thanks!
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Check row for cell greater than 0

    You can use this formula in F3:

    =IF(COUNTIF(B3:E3,"#N/A")=4,"#N/A",((COUNTIF(B3:E3,">0"))>=(4-COUNTIF(B3:E3,"#N/A")))*1)

    then copy down.

    Hope this helps.

    Pete

+ 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. Replies: 2
    Last Post: 07-26-2020, 06:37 AM
  2. Replies: 10
    Last Post: 07-22-2018, 04:00 PM
  3. [SOLVED] Formula To Check if one cell value is greater then populate another cell
    By rahul_ferns76 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-17-2016, 08:32 AM
  4. [SOLVED] Formula to check two cells greater than one other cell
    By FIFTYFINGERS in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-23-2012, 03:03 PM
  5. Replies: 2
    Last Post: 02-20-2012, 05:48 PM
  6. Can Sumproduct check for dates greater than?
    By jgomez in forum Excel General
    Replies: 3
    Last Post: 07-15-2011, 11:42 AM
  7. Check for values greater than zero in 2 cells
    By spartacus_33 in forum Excel General
    Replies: 4
    Last Post: 11-03-2008, 07:39 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