using a IF statement to return a value
 

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="0404 07",420013)))))
--
Cindy

using a IF statement to return a value
 

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" wrote in message
...
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="0404 07",420013)))))
--
Cindy

using a IF statement to return a value
 

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="0404 07",420013)))))
--
Cindy

using a IF statement to return a value
 

=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="0404 07",420013)))))
--
Cindy