Results 1 to 3 of 3

formula not recognizing the null value.

Threaded View

  1. #1
    Registered User
    Join Date
    04-09-2019
    Location
    india
    MS-Off Ver
    2016
    Posts
    2

    formula not recognizing the null value.

    Untitled.png

    I am using if formula which refer the another cell value and shows the value in formula cell or shows null value.

    Name box D10. formula followed below

    =IF(A10>0,(D9+C10),"")

    I am using another if formula which calculate the null value.

    Name box D11. formula followed below.

    =IF(A11>0,(D10+C11),"")

    The results at name box D11 is [B]#value!.

    as i understand that if formula not recognizing the null value. I advise the solve the issue.
    Last edited by slmVimalraja; 04-10-2019 at 12:58 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel not recognizing Cell in formula
    By FerociousSteve in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-17-2015, 03:14 PM
  2. Count rows with multiple null and not null criteria
    By carlostheba in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-28-2014, 05:16 AM
  3. Formula for recognizing the right rate
    By edwink85 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 06-19-2014, 05:34 AM
  4. [SOLVED] Recognizing text in formula
    By loopiloo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-28-2013, 03:50 PM
  5. [SOLVED] Index/Match formula not recognizing a row.
    By damianberry in forum Excel General
    Replies: 4
    Last Post: 11-18-2012, 11:31 AM
  6. Formula recognizing date range?
    By briannerene in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-25-2007, 10:55 PM
  7. IF formula recognizing blank cells as #NA or #NULL applicable to VBA?
    By Allison!~!@ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-06-2007, 11:12 AM

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