using a IF statement to return a value

C

Cindy M

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)))))
 
L

Luke M

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))
 
T

tech1NJ

The formula as is works. Is D9 empty by default or are you typing the account
number in manually?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nesting IF funtions 2
Multiple value if function using dates 2
Trying to combine formulas 0
Returning next item in list 1
change cell colour according to date..... 2
"IF" confusion 3
IF Formula take 2 3
Timesheet Calculation 8

Top