Thank you both - the IF(COUNT worked perfectly. The IF(ISNA returned a
#VALUE! error, maybe because the data in column L comes via
=IF(K12="","",LOOKUP(K12,$AK$12:$AK$55,$AL$12:$AL$ 55)) or more likely
because I've messed it up in the translation!!
Thanks again
Mrs T

"Luke M" wrote:

Is column L derived through a formula? I only ask because against a blank
cell, your formula should work just fine. In fact, the more common error to
see with the IF formula is the #VALUE! error, not #N/A, so I'm curious as to
what else is going on in your spreadsheet.

If problem persists, you could use an error checker. Not very fancy, but
effective:
=IF(ISNA(IF(L120,L12-G12,"")),"",IF(L120,L12-G12,""))
--
Best Regards,

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


"Mrs T." wrote:

In a list of assessment data I have current test scores in column L and the
previous test score in column G. I have a formula that works out the
difference between the 2 scores... =IF(L120,L12-G12,"") into column M, but
this returns #N/A if no test result is entered into column L which is causing
problems when I'm trying to record a macro to automatically sort data. I have
tried to change the formula to lose the #N/A but am having to admit defeat!
Data looks like this

G L M
14 15 1
14 13 -1
14 14 0

Any help greatly appreciated!!
Mrs T