software

I'm want to use an quot;IFquot; formula to compare the values in two cells and return
the following...

IF cell A is equal to cell B I want the formula cell to have a quot;Yquot; in it
IF cell A is greater than cell B by more than 2000 I want the formula cell
to have a quot;Gquot; in it
IF cell A is smaller than cell B by more than 2000 I want the formula cell
to have an quot;Rquot; in it
IF cell A is larger or smaller than cell B by less than 2000 I want the
formula cell to have a quot;Yquot; in it

Hope that makes sense, any help would be greatly appreciated...=IF(A2gt;B2 2000,quot;Gquot;,IF(A2lt;B2-2000,quot;Rquot;,quot;Yquot;))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;Langoosequot; gt; wrote in message
...
gt; I'm want to use an quot;IFquot; formula to compare the values in two cells and
return
gt; the following...
gt;
gt; IF cell A is equal to cell B I want the formula cell to have a quot;Yquot; in it
gt; IF cell A is greater than cell B by more than 2000 I want the formula cell
gt; to have a quot;Gquot; in it
gt; IF cell A is smaller than cell B by more than 2000 I want the formula cell
gt; to have an quot;Rquot; in it
gt; IF cell A is larger or smaller than cell B by less than 2000 I want the
gt; formula cell to have a quot;Yquot; in it
gt;
gt; Hope that makes sense, any help would be greatly appreciated...
gt;
quot;Langoosequot; gt; wrote in message
...
gt; I'm want to use an quot;IFquot; formula to compare the values in two cells and
gt; return
gt; the following...
gt;
gt; IF cell A is equal to cell B I want the formula cell to have a quot;Yquot; in it
gt; IF cell A is greater than cell B by more than 2000 I want the formula cell
gt; to have a quot;Gquot; in it
gt; IF cell A is smaller than cell B by more than 2000 I want the formula cell
gt; to have an quot;Rquot; in it
gt; IF cell A is larger or smaller than cell B by less than 2000 I want the
gt; formula cell to have a quot;Yquot; in it
gt;
gt; Hope that makes sense, any help would be greatly appreciated...

There was a very similar question on Friday
) from some
coincidentally also called Langoose. Look at the answer to that one and
work from there.
--
David Biddulph