Good Day.

I'm trying to create a formula for a range that says if Column A equals my
criteria, do a calculation on the same row in column D. I can do it with one
cell:

=IF(A10="Allen, Emily.Jun
02",IF((D10*1440)-4650,"",((D10*1440)-465)*-1),999) [where 999=error]

But, when I go to a range:

{=IF(A8:A1000="Allen, Emily.Jun
02",IF((D8:D1000*1440)-4650,"",((D8:D1000*1440)-465)*-1),999)}
[committed with Ctrl+Shift+Enter]

it results with "999"

I think it might be a formatting issue - both columns are formatted
"General" as they come as a data dump out of our phone system.

Any ideas?

Thanks,
Greg