Prev: Multiple conditional formating for one cell
Next: Color Me Red
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:BDB76154-7B0E-4AF6-A4F6-F5971995C86F(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