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!

=IF(D2=Z2,"No change required",IF(Y2=2005,"Update FA","Internal mapping"))

Best rgds
Chris Lav

"Cheryl B." wrote in message
...
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!

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!

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!