|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 10th, 2006, 08:01 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
How to assign #N/A N.A. data?
Hi, I need help, i just wanted a formula to assign "#N/A N.A." into "----", which is blank. thanks in advance.  -- jolly79_ph ------------------------------------------------------------------------ jolly79_ph's Profile: http://www.excelforum.com/member.php...fo&userid=4835 View this thread: http://www.excelforum.com/showthread...hreadid=499652 
|
|
#2
January 10th, 2006, 10:00 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to assign #N/A N.A. data?
Can you post your formula ? You'd probably receive better, more specific
responses that you could then apply direct into your sheet. Anyway, one usual way to error-trap #N/A errors is to use something like: =IF(ISNA(formula),"---",formula) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "jolly79_ph" wrote in message ... Hi, I need help, i just wanted a formula to assign "#N/A N.A." into "----", which is blank. thanks in advance. -- jolly79_ph ------------------------------------------------------------------------ jolly79_ph's Profile: http://www.excelforum.com/member.php...fo&userid=4835 View this thread: http://www.excelforum.com/showthread...hreadid=499652
|
|
#3
January 10th, 2006, 10:10 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to assign #N/A N.A. data?
i dont quite understand what "#N/A N.A." is but if you mean that you dont
want the error value #N/A to show but to have a blank intead then =if(isna(your formula which may result in a #N/A error),"",your formula which may result in a#N/A error)) -- paul remove nospam for email addy! "jolly79_ph" wrote: Hi, I need help, i just wanted a formula to assign "#N/A N.A." into "----", which is blank. thanks in advance. -- jolly79_ph ------------------------------------------------------------------------ jolly79_ph's Profile: http://www.excelforum.com/member.php...fo&userid=4835 View this thread: http://www.excelforum.com/showthread...hreadid=499652
|
|
#4
January 10th, 2006, 11:01 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to assign #N/A N.A. data?
=IF(ISNA(formula),"---",formula)
Just to clarify that the above construct will return: "---" if formula evaluates to an #N/A If you want blanks: "" to be returned instead, just replace "---" with "" in the construct -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 --
|
|
#5
January 10th, 2006, 11:22 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to assign #N/A N.A. data?
Its a computer generated linked in futures contract table price: low, high, close, previous, i encounter this #N/A N.A., in low and high, but it's normal there is no figure on low & high column price sometimes, but instead of #N/A N.A., i wanted to replace with "----", to make appropriate to look, which means, the low and high price data is not available. I hope this is clear for you. -- jolly79_ph ------------------------------------------------------------------------ jolly79_ph's Profile: http://www.excelforum.com/member.php...fo&userid=4835 View this thread: http://www.excelforum.com/showthread...hreadid=499652
|
|
#6
January 10th, 2006, 04:46 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to assign #N/A N.A. data?
Assuming source data in A1 down
Try in say, B1: =IF(A1="","",IF(ISNUMBER(FIND("#N/A N.A.",A1)),"----",A1)) Copy down -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "jolly79_ph" wrote in message ... Its a computer generated linked in futures contract table price: low, high, close, previous, i encounter this #N/A N.A., in low and high, but it's normal there is no figure on low & high column price sometimes, but instead of #N/A N.A., i wanted to replace with "----", to make appropriate to look, which means, the low and high price data is not available. I hope this is clear for you. -- jolly79_ph ------------------------------------------------------------------------ jolly79_ph's Profile: http://www.excelforum.com/member.php...fo&userid=4835 View this thread: http://www.excelforum.com/showthread...hreadid=499652
|
|
#7
January 15th, 2006, 05:14 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to assign #N/A N.A. data?
It really works!, its amazing, it's a been a big problem with me of this redundant job, and have to change this #N/A N.A. one by one. Its worthy of praise to Max xl 97, your are a guru in excel. Im glad i've signed up in this worthy forum for the new excel users. thanks a lot clap!clap!jolly79_ph -- jolly79_ph ------------------------------------------------------------------------ jolly79_ph's Profile: http://www.excelforum.com/member.php...fo&userid=4835 View this thread: http://www.excelforum.com/showthread...hreadid=499652
|
|
#8
January 15th, 2006, 09:51 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to assign #N/A N.A. data?
Welcome back, and glad to hear it worked for you !
Thanks for the feedback .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "jolly79_ph" wrote in message ... It really works!, its amazing, it's a been a big problem with me of this redundant job, and have to change this #N/A N.A. one by one. Its worthy of praise to Max xl 97, your are a guru in excel. Im glad i've signed up in this worthy forum for the new excel users. thanks a lot clap!clap!jolly79_ph -- jolly79_ph ------------------------------------------------------------------------ jolly79_ph's Profile: http://www.excelforum.com/member.php...fo&userid=4835 View this thread: http://www.excelforum.com/showthread...hreadid=499652
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Cross program data sharing | m_jurrens | Powerpoint | 1 | December 16th, 2005 04:36 PM |
| Excel Macro to Copy & Paste | [email protected] | Worksheet Functions | 0 | December 1st, 2005 01:56 PM |
| From several workbooks onto one excel worksheet | steve | General Discussion | 6 | December 1st, 2005 08:03 AM |
| Unable to have multiple queries feeding a single report | PZ Straube | Setting Up & Running Reports | 15 | June 15th, 2005 08:16 AM |
| Sort pages? | David | General Discussion | 15 | May 13th, 2005 11:33 PM |
Linear Mode
