why the the formula result is showing up to be incorrect boolean value in the excel document? excel page attached.
why the the formula result is showing up to be incorrect boolean value in the excel document? excel page attached.
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.
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
d2 value is 125 not 0
my apologies i made a mistake in putting the data in the wrong cell. you have answered correctly.
you are welcome
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks