Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"IF" Formula Query...
=IF(A2B2+2000,"G",IF(A2<B2-2000,"R","Y"))
-- HTH Bob Phillips (remove xxx from email address if mailing direct) "Langoose" wrote in message ... 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... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"IF" Formula Query...
"Langoose" wrote in message
... 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. -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
"IF" formula returns zero or other incorrect number | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
How to correctly write a cross-sheet "IF" formula in Excel | Excel Worksheet Functions | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) |