ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Why does this fail? =TEXT(RC3,Number)&" / "&TEXT(R32C,Number) (https://www.excelbanter.com/excel-worksheet-functions/32041-why-does-fail-%3Dtext-rc3-number-%22-%22-text-r32c-number.html)

=TEXT(RC3,Number)& / &TEXT(R32C,Number

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.

Alan

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.




garfield-n-odie

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.




All times are GMT +1. The time now is 07:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com