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" <[email protected]> wrote in message
news:[email protected]...
> 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]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
>
>
>

[Bill Kuunders]

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

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> >> 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