IF statement

C

cbuck

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?
 
C

cbuck

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?
 
G

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.
 
C

cbuck

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.
 
R

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?
Click to expand...

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


--ron
 
Top