From: Cindy M on 26 Mar 2010 16:11 trying to have my formula to either give me an account number or D9 is blank return a value of "blank" =IF(D9="040410",411000,IF(D9="040428",420026,IF(D9="040403",420011,IF(D9="040405",420028,IF(D9="040407",420013)))))  Cindy
From: Luke M on 26 Mar 2010 16:23 Instead of having all that info in a formula where it's ahrder to audit/change, consider building a lookup table. Then your formula could be condensed to: =IF(D9="","",LOOKUP(D9,Table_Reference))  Best Regards, Luke M "Cindy M" <CindyM(a)discussions.microsoft.com> wrote in message news:BDB761547B0E4AF6A4F6F5971995C86F(a)microsoft.com... > trying to have my formula to either give me an account number or D9 is > blank > return a value of "blank" > > > =IF(D9="040410",411000,IF(D9="040428",420026,IF(D9="040403",420011,IF(D9="040405",420028,IF(D9="040407",420013))))) >  > Cindy
From: tech1NJ on 26 Mar 2010 16:28 The formula as is works. Is D9 empty by default or are you typing the account number in manually?  tech1NJ "Cindy M" wrote: > trying to have my formula to either give me an account number or D9 is blank > return a value of "blank" > > > =IF(D9="040410",411000,IF(D9="040428",420026,IF(D9="040403",420011,IF(D9="040405",420028,IF(D9="040407",420013))))) >  > Cindy
From: Russell Dawson on 26 Mar 2010 16:51 =IF(D9="","",IF(D9="040410",411000,IF(D9="040428",420026,IF(D9="040403",420011,IF(D9="040405",420028,IF(D9="040407",420013))))))  Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Cindy M" wrote: > trying to have my formula to either give me an account number or D9 is blank > return a value of "blank" > > > =IF(D9="040410",411000,IF(D9="040428",420026,IF(D9="040403",420011,IF(D9="040405",420028,IF(D9="040407",420013))))) >  > Cindy

Pages: 1 Prev: Multiple conditional formating for one cell Next: Color Me Red 