IF statement

[Guest]

The following IF statement is not working:
=if(A1>B1, "", 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?

 

[Guest]

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?

 

[Guest]

Hi

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

Andy.

 

[Guest]

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.

 

[Ron Rosenfeld]

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