Thread: using a IF statement to return a value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cindy M Cindy M is offline
external usenet poster
  
Posts: 1
Default 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
Reply With QuoteReply With Quote