Help with IF Statement
That's IT, B.J. - thanks sooooo much!
"bj" wrote:
if I am reading your post correctly
try
=if(d2=z2,"No Change Required",if(y2=2005,"Update FA","Internal Mapping"))
or if y2 is in a date format
=if(d2=z2,"No Change Required",if(year(y2)=2005,"Update FA","Internal
Mapping"))
"Cheryl B." wrote:
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!
|