need help with expression

[Peterpunkin]

How would I express the following: " if the cell to the left has N/A in it,
place N/A in this cell also, otherwise do nothing"
very grateful for your assistance

[Gazzr]

Hi Mate,

Copy this formula into cell G19, assuming that F19 contains #N/A

=IF(F19="#N/A","#N/A","")

Thanks
gazzr

[Peterpunkin]

I have 15,000 other rows that contain numbers which are a function of the
cell to their left that I need to not change. I am looking for an entry I
can apply to the whole column that will only change this formula when it
finds an N/A in the cell to the left but otherwise do nothing.
sorry if I was not clear, i'm obviously kind of new at this.

"Gazzr" wrote:

>
> Hi Mate,
>
> Copy this formula into cell G19, assuming that F19 contains #N/A
>
> =IF(F19="#N/A","#N/A","")
>
> Thanks
> gazzr
>
>
> --
> Gazzr
> ------------------------------------------------------------------------
> Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075
> View this thread: http://www.excelforum.com/showthread...hreadid=538757
>
>

[Gazzr]

Hi again,

How about:

=IF(F19="#N/A",INSERT YOUR FORMULA HERE,"OR DO NOTHING?")

I'm new at this too so dont worry. If that's no good maybe post an example of what you want to acheive. Seeing an example of what you want to achieve might help get my brain into gear!

Regards
Gazzr

[Bob Phillips]

For example, in G2

=IF(ISNA(G1),G1,"")

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Peterpunkin" <[email protected]> wrote in message
news:[email protected]...
> How would I express the following: " if the cell to the left has N/A in
it,
> place N/A in this cell also, otherwise do nothing"
> very grateful for your assistance

[Dominic]

I'm a little confused.

Does the example below match your data?

A B C
value value value
value value value
value n/a ???
value value value

Where column C has a formula based on column B.

You would like column C to show N/A when column B shows N/A.

If so, what does column C show now when column B is n/a?

What is the formula in column C?

"Peterpunkin" wrote:

> I have 15,000 other rows that contain numbers which are a function of the
> cell to their left that I need to not change. I am looking for an entry I
> can apply to the whole column that will only change this formula when it
> finds an N/A in the cell to the left but otherwise do nothing.
> sorry if I was not clear, i'm obviously kind of new at this.
>
> "Gazzr" wrote:
>
> >
> > Hi Mate,
> >
> > Copy this formula into cell G19, assuming that F19 contains #N/A
> >
> > =IF(F19="#N/A","#N/A","")
> >
> > Thanks
> > gazzr
> >
> >
> > --
> > Gazzr
> > ------------------------------------------------------------------------
> > Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075
> > View this thread: http://www.excelforum.com/showthread...hreadid=538757
> >
> >