software

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

quot;cbuckquot; wrote:

gt; The following IF statement is not working:
gt; =if(A1gt;B1, quot;quot;, B1-A1)
gt;
gt; Value in cell B1 is greater than the value in cell A1, but the statement is
gt; returning a blank, as if value in B1 is less than value in A1.
gt;
gt; Any thoughts?

Hi

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

Andy.

quot;cbuckquot; gt; wrote in message
...
gt; The following IF statement is not working:
gt; =if(A1gt;B1, quot;quot;, B1-A1)
gt;
gt; Value in cell B1 is greater than the value in cell A1, but the statement
gt; is
gt; returning a blank, as if value in B1 is less than value in A1.
gt;
gt; 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.

quot;AndyBquot; wrote:

gt; Hi
gt;
gt; Your logic is right, but you say that B1 is greater than A1, so the formula
gt; is supposed to return a blank!
gt;
gt; Andy.
gt;
gt; quot;cbuckquot; gt; wrote in message
gt; ...
gt; gt; The following IF statement is not working:
gt; gt; =if(A1gt;B1, quot;quot;, B1-A1)
gt; gt;
gt; gt; Value in cell B1 is greater than the value in cell A1, but the statement
gt; gt; is
gt; gt; returning a blank, as if value in B1 is less than value in A1.
gt; gt;
gt; gt; Any thoughts?
gt;
gt;
gt;

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

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

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