Is there a better way than using a nested "IF" statement to test value in D5 and return value of E5 if a correct value in D5 is found?

[blbat]

Cell D5 may contain the text strings of "Window XP", "Windows 2003", "Windows 2008', "Windows 10". or it may contain something completely irrelevant.


=IF(D5="Windows XP",E5,IF(D5="Windows 2003",E5,IF(D5="Windows 2003 R2",E5,IF(D5="Windows 2003 R2",E5,IF(D5="Windows 2008",E5,IF(D5="Windows 10",E5,"ZERO"))))))



That nested IF formula works fine, but is there a "better" way? (i.e., faster, or cleaner)

 

[Fluff]

One option would be like
=IF(OR(D5="Windows XP",D5="Windows 2003",D5="Windows 2003 R2"),E5,"ZERO")

 

[Norie]

Another option.

=IF(OR(D5={"Windows XP","Windows 2003","Windows 2003 R2"}), E5, "ZERO")

 

[blbat]

Thanks Gents.

I figured there was a way to work an array formula...I just couldn't draft it up.

 

[Norie]

Neither of the formulas suggested are array formulas.

 

[blbat]

doesn't the "curly brackets" with C/S/E make it an array? if not I am using the wrong terminology.

 

[Norie]

The values in the curly brackets are an 'array' but the formula isn't an array formula so doesn't need to be entered with CTRL+SHIFT+ENTER.