Anthony,

Use a formula like the following;

=IF('Invoice Data'!R2=0,NA(),'Invoice Data'!R2)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Anthony" wrote in message
...
me again !!

I'll get the hang of excel -on day!

anyway heres the question

if the value of 'Invoice Data'!R2 = £0.00 I want n/a shown in
cell I26, but
if there is a value other than £0.00 in 'Invoice Data'!R2 ,
then show that in
cell I26.

Hope that's clear and thanks again