Another Formula question - please
 

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

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

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

Oops
=IF('Invoice Data'!R2=0,"n/a",'Invoice Data'!R2)
too late in the night Chip?
( :))
Bill K
"Chip Pearson" wrote in message
...
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

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.

Bill Kuunders wrote:

Oops
=IF('Invoice Data'!R2=0,"n/a",'Invoice Data'!R2)
too late in the night Chip?
( :))
Bill K
"Chip Pearson" wrote in message
...
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




--

Dave Peterson