Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Alternative to Nested IFs in Excel



Here's and example:

IF(NOT(ISERROR(FIND("Incident Created",A2))),"Incident Created page",""))&IF(AND(ISERROR(FIND(" | ",A2)),ISERROR(FIND("Community",A2)),ISERROR(FIND("Search Results",A2))),"Help Landing page","")
Note the false condition sets an empty value.

I see a benefit in that the code is much easier to read, as nesting can become difficult to follow. The down side is you need to test the negative condition of other IFs so you don't have multiple matches.


This post first appeared on CHRISdotTODD, please read the originial post: here

Share the post

Alternative to Nested IFs in Excel

×

Subscribe to Chrisdottodd

Get updates delivered right to your inbox!

Thank you for your subscription

×