Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I think I'm close but am off on the structure and/or syntax. I have three
different conditions for which I need three different results. It may be a no-brainer for some but it's about to drive me crazy. Can anybody help? Condition Result Tag 1 = Tag 2 No Change Required Tag 1 < Tag 2 and Year equal to 2005 Update FA Tag 1 < Tag 2 and Year not equal to 2005 Internal Mapping Cell D2 = Tag 1 Cell Z2 = Tag 2 Cell Y2 = Year Substituting elements with cells, it looks like this: D2 = Z2 No Change Required D2 < Z2 and Y2 = 2005 Update FA D2 < Z2 and Y2 < 2005 Map Internally But I don't seem to be able to get all in one string for one cell ... Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
IF Statement nightmare | Excel Discussion (Misc queries) | |||
IF Statement | New Users to Excel | |||
What statement to use? | Excel Worksheet Functions |