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?

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?

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

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?

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?