software

Hi, I need help, i just wanted a formula to assign quot;#N/A N.A.quot; into
quot;----quot;, which is blank. thanks in advance. --
jolly79_ph
------------------------------------------------------------------------
jolly79_ph's Profile: www.excelforum.com/member.php...foamp;userid=4835
View this thread: www.excelforum.com/showthread...hreadid=499652Can 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(lt;formulagt;),quot;---quot;,lt;formulagt;)

--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--
quot;jolly79_phquot; gt; wrote
in message ...
gt;
gt; Hi, I need help, i just wanted a formula to assign quot;#N/A N.A.quot; into
gt; quot;----quot;, which is blank. thanks in advance.
gt;
gt;
gt; --
gt; jolly79_ph
gt; ------------------------------------------------------------------------
gt; jolly79_ph's Profile:
www.excelforum.com/member.php...foamp;userid=4835
gt; View this thread: www.excelforum.com/showthread...hreadid=499652
gt;
i dont quite understand what quot;#N/A N.A.quot; 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),quot;quot;,your formula which
may result in a#N/A error))

--
paul
remove nospam for email addy!
quot;jolly79_phquot; wrote:

gt;
gt; Hi, I need help, i just wanted a formula to assign quot;#N/A N.A.quot; into
gt; quot;----quot;, which is blank. thanks in advance.
gt;
gt;
gt; --
gt; jolly79_ph
gt; ------------------------------------------------------------------------
gt; jolly79_ph's Profile: www.excelforum.com/member.php...foamp;userid=4835
gt; View this thread: www.excelforum.com/showthread...hreadid=499652
gt;
gt;

gt; =IF(ISNA(lt;formulagt;),quot;---quot;,lt;formulagt;)

Just to clarify that the above construct will return: quot;---quot;
if lt;formulagt; evaluates to an #N/A

If you want blanks: quot;quot; to be returned instead,
just replace quot;---quot; with quot;quot; in the construct
--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--

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 amp; high column price sometimes, but
instead of #N/A N.A., i wanted to replace with quot;----quot;, 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: www.excelforum.com/member.php...foamp;userid=4835
View this thread: www.excelforum.com/showthread...hreadid=499652Assuming source data in A1 down

Try in say, B1:
=IF(A1=quot;quot;,quot;quot;,IF(ISNUMBER(FIND(quot;#N/A N.A.quot;,A1)),quot;----quot;,A1))
Copy down
--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--
quot;jolly79_phquot; gt; wrote
in message ...
gt;
gt; Its a computer generated linked in futures contract table price: low,
gt; high, close, previous, i encounter this #N/A N.A., in low and high, but
gt; it's normal there is no figure on low amp; high column price sometimes, but
gt; instead of #N/A N.A., i wanted to replace with quot;----quot;, to make
gt; appropriate to look, which means, the low and high price data is not
gt; available. I hope this is clear for you.
gt;
gt;
gt; --
gt; jolly79_ph
gt; ------------------------------------------------------------------------
gt; jolly79_ph's Profile:
www.excelforum.com/member.php...foamp;userid=4835
gt; View this thread: www.excelforum.com/showthread...hreadid=499652
gt;

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: www.excelforum.com/member.php...foamp;userid=4835
View this thread: www.excelforum.com/showthread...hreadid=499652Welcome back, and glad to hear it worked for you !
Thanks for the feedback ..
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;jolly79_phquot; gt; wrote
in message ...
gt;
gt; It really works!, its amazing, it's a been a big problem with me of
gt; this redundant job, and have to change this #N/A N.A. one by one. Its
gt; worthy of praise to Max xl 97, your are a guru in excel. Im glad i've
gt; signed up in this worthy forum for the new excel users.
gt;
gt; thanks a lot clap!clap!
gt; jolly79_ph
gt;
gt;
gt; --
gt; jolly79_ph
gt; ------------------------------------------------------------------------
gt; jolly79_ph's Profile:
www.excelforum.com/member.php...foamp;userid=4835
gt; View this thread: www.excelforum.com/showthread...hreadid=499652
gt;