+ Reply to Thread
Results 1 to 7 of 7

excel formula outputting incorrect boolean value

  1. #1
    Registered User
    Join Date
    04-22-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    3

    excel formula outputting incorrect boolean value

    why the the formula result is showing up to be incorrect boolean value in the excel document? excel page attached.
    Attached Files Attached Files

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX, 365 for windows, Windows 10 Insider
    Posts
    5,805

    Re: excel formula outputting incorrect boolean value

    D2 is less than A2
    blank cell counts as zero
    blank cell in D2 is less than 123 in A2
    blank cell in D2 Zero is not greater > than 123 in A2
    so D2>A2 is false
    change D2 to 10000
    and it becomes true
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    2010
    Posts
    2,062

    Re: excel formula outputting incorrect boolean value

    you have not said what the results should be
    d2 is 0 or blank
    a2 is 123

    so d2 is not bigger than a2 therefor the answer is false


    what are you trying to do

  4. #4
    Registered User
    Join Date
    04-22-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    3

    Re: excel formula outputting incorrect boolean value

    d2 value is 125 not 0

  5. #5
    Registered User
    Join Date
    04-22-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    3

    Re: excel formula outputting incorrect boolean value

    my apologies i made a mistake in putting the data in the wrong cell. you have answered correctly.

  6. #6
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX, 365 for windows, Windows 10 Insider
    Posts
    5,805

    Re: excel formula outputting incorrect boolean value

    you are welcome

  7. #7
    Registered User
    Join Date
    04-26-2020
    Location
    Massachusetts
    MS-Off Ver
    Office 365
    Posts
    68

    Re: excel formula outputting incorrect boolean value

    Formula b1 =IF(D1>A21,"True","False") Then copy down to rest of cells. When they are equal it is still "False" as you specified greater than >

    I attached a copy of your database with this change.


    if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Attached Files Attached Files

+ 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. Problem with Excel formula returning #VALUE! or Incorrect result
    By Buddy8 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-03-2016, 06:14 AM
  2. [SOLVED] Exit Workbook_BeforeClose(Cancel As Boolean) if a public boolean = true
    By meabrams in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-20-2016, 06:10 AM
  3. [SOLVED] Excel 2010 - SUM formula returns incorrect result
    By digita in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-15-2016, 01:06 AM
  4. [SOLVED] Forumula Results Incorrect when data missing. Wanting to hide the incorrect formula.
    By firemedic6265 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-05-2014, 05:01 PM
  5. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) problem
    By 2funny4words in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2009, 07:28 PM
  6. [SOLVED] feel that the STANDARD DEVIATION formula on Excel is incorrect !!
    By Ganapati Hegde in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-18-2005, 12:15 PM
  7. Outputting a formula in a cell using VB
    By Cardiff Maths Student in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-06-2005, 08:06 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