Another Formula question - please

[Anthony]

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

 

[Chip Pearson]

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]

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

 

[Bill Kuunders]

Oops
=IF('Invoice Data'!R2=0,"n/a",'Invoice Data'!R2)
too late in the night Chip?
( :>))
Bill K

 

[Dave Peterson]

Depends on what you want.

Chip's formula (using na()) will return an error--just like =vlookup() will when
there's no match.

It will look like #N/A, though.