Sorry about that. Parentheses are key.
--
Brevity is the soul of wit.


"A.S." wrote:

Nevermind. Got it, Thanks! It was a paranthesis issue.

"Dave F" wrote:

=IF(AND(ISNA(A1),ISNA(B1),"",IF(AND(ISNA(A1),ISNUM BER(B1),"END",IF(AND(ISNUMBER(A1),ISNA(B1),"START" ,"DONE")))

Dave
--
Brevity is the soul of wit.


"A.S." wrote:

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.