Hi Chip,
thanks for the help I just need to add "" around the n/a and it worked.
Many thanks


"Chip Pearson" wrote:

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