Hi Luke,

It is ok for it check it is a number. If both col's are blank, then it can
return blank. N/A is pulled through from the database automatically if this
part of the process isn't needed. Hope this helps a bit more :-)

"Luke M" wrote:

Is it okay if it just checks to see if its a number? (since dates are
technically larger numbers). What happens if both column A and column B are
blank? Also, when you mention N/A, do you mean you enter "N/A" or the N/A
error is displayed?

Former:
=IF(ISNUMBER(A2),A2,IF(AND(OR(ISBLANK(A2),A2="N/A"),ISNUMBER(B2)),B2,"Conditions not met"))
Latter:
=IF(ISNUMBER(A2),A2,IF(AND(OR(ISBLANK(A2),ISNA(A2) ),ISNUMBER(B2)),B2,"Conditions not met"))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"hjm" wrote:

Can the following be done?
If there is a date in column A, then return A otherwise if it is blank or
N/A look at column B & if there is a date there return col B.

Hope someone can help.

Thanks!