Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagRe: IF Function Referencing Multiple & Return Blank scolgate Yes, the innermost IF needs a value to return: =IF(D5="Example1",5,IF(D5="Example2",10,IF(D5="Example3",15,IF(D5="Example4",20,"")))) Re: Excel speedo2 Is the data on more than one sheet?