LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Return Value using If statement or Lookup? Malva Excel Worksheet Functions 2 June 24th 09 09:42 PM
Carriage return during an if statement kpt Excel Discussion (Misc queries) 2 May 15th 09 05:31 PM
Return Vavle base on statement Larry Excel Worksheet Functions 2 October 31st 08 12:03 PM
Return range of values on an "IF" statement KelleyS Excel Worksheet Functions 0 June 1st 05 08:32 PM
Vlookup of an if statement return James Excel Worksheet Functions 2 April 6th 05 10:28 PM


All times are GMT +1. The time now is 05:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"