View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Langoose
 
Posts: n/a
Default "IF" Formula Query...

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