Help with IF Statement

C

Cheryl B.

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!
 
C

Chris Lavender

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

Best rgds
Chris Lav
 
B

bj

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"))
 
C

Cheryl B.

That's IT, B.J. - thanks sooooo much!

bj said:
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"))
Click to expand...
 
Top