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.
|