IF statement
 

The following IF statement is not working:
=if(A1B1, "", B1-A1)

Value in cell B1 is greater than the value in cell A1, but the statement is
returning a blank, as if value in B1 is less than value in A1.

Any thoughts?

IF statement
 

I figured out the problem, but it leads to another question. B1 does not
contain a value or expression; it contains an 'image' of a number that was
downloaded from a website. Is there a way to change what is in B1 to a value
or expression?

"cbuck" wrote:

The following IF statement is not working:
=if(A1B1, "", B1-A1)

Value in cell B1 is greater than the value in cell A1, but the statement is
returning a blank, as if value in B1 is less than value in A1.

Any thoughts?

IF statement
 

Hi

Your logic is right, but you say that B1 is greater than A1, so the formula
is supposed to return a blank!

Andy.

"cbuck" wrote in message
...
The following IF statement is not working:
=if(A1B1, "", B1-A1)

Value in cell B1 is greater than the value in cell A1, but the statement
is
returning a blank, as if value in B1 is less than value in A1.

Any thoughts?

IF statement
 

And I worked so hard to make sure I phrased the question right. Shows you
what hard work yields. Anyway, I was able to find the =VALUE function, which
converted text to value just fine.

"AndyB" wrote:

Hi

Your logic is right, but you say that B1 is greater than A1, so the formula
is supposed to return a blank!

Andy.

"cbuck" wrote in message
...
The following IF statement is not working:
=if(A1B1, "", B1-A1)

Value in cell B1 is greater than the value in cell A1, but the statement
is
returning a blank, as if value in B1 is less than value in A1.

Any thoughts?

IF statement
 

On Tue, 14 Mar 2006 08:48:19 -0800, cbuck
wrote:

I figured out the problem, but it leads to another question. B1 does not
contain a value or expression; it contains an 'image' of a number that was
downloaded from a website. Is there a way to change what is in B1 to a value
or expression?

You'll need to run it though an Optical Character Recognition program.


--ron