On Thu, 2 Apr 2009 14:23:03 -0700, Eddie
wrote:

Hello all, I have a someone sharing excel 2007 spreadsheets with others using
excel 2003. She is saving it in the 2003 format and everyone has the
neccesary toopak addin's installed but they randomly get the #N/A error with
the following formula's:

=(YIELD(TODAY()+3,L11,((VLOOKUP(YEAR(L11)-YEAR(TODAY()),$Q$12:$R$27,2,FALSE)+J12/100))/100,I12,100,4)*100)

=YIELD($AC$1,K4,D4+$T$2,I4,100,4)


Is there any workaround to this compatibility issue? or do they all need to
be on the same version?

Thanks in advance,
Eddie

What makes you think it is a compatibility issue?

The #N/A error can arise for many reasons.
--ron