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

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

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

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


--
Gazzr
------------------------------------------------------------------------
Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075
View this thread: http://www.excelforum.com/showthread...hreadid=538757

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

For example, in G2

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Peterpunkin" wrote in message
...
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