Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return Value using If statement or Lookup? | Excel Worksheet Functions | |||
Carriage return during an if statement | Excel Discussion (Misc queries) | |||
Return Vavle base on statement | Excel Worksheet Functions | |||
Return range of values on an "IF" statement | Excel Worksheet Functions | |||
Vlookup of an if statement return | Excel Worksheet Functions |