A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Why does this fail? =TEXT(RC3,Number)&" / "&TEXT(R32C,Number)



 
 
Thread Tools Display Modes
  #1  
Old June 23rd, 2005, 12:20 AM
=TEXT(RC3,Number)& / &TEXT(R32C,Number
external usenet poster
 
Posts: n/a
Default Why does this fail? =TEXT(RC3,Number)&" / "&TEXT(R32C,Number)

I get the fatal #Name? error with this and none of the help suggestions makes
any difference. All I'm trying to do is use numbers to write a text
expression. Why aren't examples included with your help? I've been
using Maple, and their examples are very helpful.
  #2  
Old June 23rd, 2005, 12:37 AM
Alan
external usenet poster
 
Posts: n/a
Default

Try this, I haven't used the R1C1 references,
=TEXT(A1,"0.0")&" / "&TEXT(A2,"0.0")
you can adjust "0.0" to display the number of decimals you need,
Regards,
Alan.
...
I get the fatal #Name? error with this and none of the help suggestions
makes
any difference. All I'm trying to do is use numbers to write a text
expression. Why aren't examples included with your help? I've been
using Maple, and their examples are very helpful.



  #3  
Old June 23rd, 2005, 01:02 AM
garfield-n-odie
external usenet poster
 
Posts: n/a
Default

Because "Number" is not a valid argument in the TEXT function.
Instead, use something like "$0.00" or "0%" or "-1234". I'm not
sure why you even need the TEXT function, because I was able to
make it work with just =RC3&" / "&R32C .

RC3,Number wrote:

I get the fatal #Name? error with this and none of the help suggestions makes
any difference. All I'm trying to do is use numbers to write a text
expression. Why aren't examples included with your help? I've been
using Maple, and their examples are very helpful.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access2K append queries fail under XP Pro [email protected] Running & Setting Up Queries 1 May 25th, 2005 08:46 PM
need to return Pass or Fail to text box or label dtoney New Users 4 February 8th, 2005 06:31 PM
Queries fail for certain users on certain machines Jeff Vandervoort Running & Setting Up Queries 0 January 25th, 2005 12:37 AM
pass fail Tricia New Users 3 January 20th, 2005 03:45 PM
PASS or FAIL? Param Worksheet Functions 5 July 16th, 2004 10:55 AM


All times are GMT +1. The time now is 09:23 AM.


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