"IF" Formula Query...

[Guest]

I'm want to use an "IF" 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 "Y" in it
IF cell A is greater than cell B by more than 2000 I want the formula cell
to have a "G" in it
IF cell A is smaller than cell B by more than 2000 I want the formula cell
to have an "R" in it
IF cell A is larger or smaller than cell B by less than 2000 I want the
formula cell to have a "Y" in it

Hope that makes sense, any help would be greatly appreciated...

 

[Bob Phillips]

=IF(A2>B2+2000,"G",IF(A2<B2-2000,"R","Y"))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[David Biddulph]

I'm want to use an "IF" 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 "Y" in it
IF cell A is greater than cell B by more than 2000 I want the formula cell
to have a "G" in it
IF cell A is smaller than cell B by more than 2000 I want the formula cell
to have an "R" in it
IF cell A is larger or smaller than cell B by less than 2000 I want the
formula cell to have a "Y" in it

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.