Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Peterpunkin
 
Posts: n/a
Default need help with expression

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gazzr
 
Posts: n/a
Default need help with expression


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

  #3   Report Post  
Posted to microsoft.public.excel.misc
Peterpunkin
 
Posts: n/a
Default need help with expression

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


  #4   Report Post  
Posted to microsoft.public.excel.misc
Gazzr
 
Posts: n/a
Default need help with expression


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

  #5   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default need help with expression

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





  #6   Report Post  
Posted to microsoft.public.excel.misc
Dominic
 
Posts: n/a
Default need help with expression

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you determine if a field is blank in a logical expression. Van Excel Discussion (Misc queries) 2 December 5th 05 11:08 PM
Expression for Macro - help Pasmatos Excel Discussion (Misc queries) 4 November 28th 05 08:02 PM
Excel expression {=SUm(if(istext(c8:k8),1,0))} Mike Excel Worksheet Functions 2 October 11th 05 07:12 PM
Can Excel represent formula in textural format with values substi. BoneR Excel Worksheet Functions 7 March 31st 05 03:11 PM
Excel Expression Yubasus Excel Discussion (Misc queries) 2 November 26th 04 01:41 AM


All times are GMT +1. The time now is 03:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"