View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
A.S. A.S. is offline
external usenet poster
 
Posts: 79
Default Need formula help

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.