Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
Here is some sample data: 1 1 #N/A #N/A #N/A #N/A #N/A #N/A 12 #N/A #N/A 25 So basically, I am looking for a formula that will tell me if the item in column 1 is a number and item in column 2 is a number then it will put "DONE", if item in column 1 is a number and item in column 2 is "#N/A", then it will put "START", if item in column 1 is "#N/A" and item in column 2 is a number it will put "END", otherwise if both columns are "#N/A", it will leave blank. Any ideas. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |