How can i comnvert the numerical degits in to text autometically in a specified text. for exeample: Cell A1 contains 100 value and Cell A2 contains 200 value. Now If Cell C1=A1+A2 then the C1 Will show the value 300. Now I want that in Cell D2 the value of C1 will be expressed in Text, i,e, "Rupees Three Hundred Only" --like this. Please help. Raju Saha You can also reply to rajusahantc@gmail.com

Re: Numaric to TEXT

Raju, There's no easy way to do it as far as I know. What you can do is create a table where in column A you'll have the sum, in this case 300 and in column B you'll have the text i.e. Rupees Three Hundred Only Then you need to use the Vlookup function to retrieve the right text to the number you get.

Posted on Sep 18, 2007

If the value in A1 is 100, and the value of A2 is 120, then the formula =(A2/A1)-1 will return 0.2. If the cell containing the formula is then formatted to display as percentage it will show as 20%.

Dec 13, 2013 | Microsoft Excel for PC

Use the **test** function.

Formula in cell A1 would be**=text(a2,"dddd").**

This would pick up the date from cell A2 and return the day of the week in cell A1.

Formula in cell A1 would be

This would pick up the date from cell A2 and return the day of the week in cell A1.

Jun 06, 2010 | Microsoft Excel for PC

#VALUE? is an error indication meaning that Excel can't process the formula. It is most likely the result of a bad cell reference in your formula, for example, you may be trying to perform mathematical operations on a cell that contains non-numeric text data.

Jul 21, 2009 | Microsoft Office Excel 2007

I hope this helps and thanks for rating my effort...any other questions...shoot em to me....The Fang.

Restricting character input You can use the SetInputTextType command to restrict the characters that the user can enter in the text input dialog box. For example, suppose an application contains an input text field for users to provide a numeric value, such as their age, and that the input text field has the variable name ageVar. To ensure that the user enters only numeric values in the text input dialog box, you could add the following code to your application:

fscommand2("SetInputTextType", "ageVar", "Numeric");

When users open the input text dialog box, they can enter only numeric values in the text fields.

For more information, see SetInputTextType in the fscommand2 function entry in the*Flash Lite 2.x ActionScript Language Reference*.

Restricting character input You can use the SetInputTextType command to restrict the characters that the user can enter in the text input dialog box. For example, suppose an application contains an input text field for users to provide a numeric value, such as their age, and that the input text field has the variable name ageVar. To ensure that the user enters only numeric values in the text input dialog box, you could add the following code to your application:

fscommand2("SetInputTextType", "ageVar", "Numeric");

When users open the input text dialog box, they can enter only numeric values in the text fields.

For more information, see SetInputTextType in the fscommand2 function entry in the

May 28, 2009 | Adobe Flash® CS3 Professional Full Version...

Use this formula in B1: =CHOOSE(A1,"GOOD","FAIR","BAD")

With this you must have 1, 2, or 3 in A1 or you will get a #VALUE error in B1.

With this you must have 1, 2, or 3 in A1 or you will get a #VALUE error in B1.

May 20, 2009 | Microsoft EXCEL 2004 for Mac

To find the second character in a string in A1 use =mid(A2,2,1)

To check if it is a number use =isnumber(value(mid(A2,2,1)))

I hope this helps to get past the part you are stuck on - not being familiar with your problem it's difficult to give you any more advice.

To check if it is a number use =isnumber(value(mid(A2,2,1)))

I hope this helps to get past the part you are stuck on - not being familiar with your problem it's difficult to give you any more advice.

Mar 12, 2009 | Microsoft Office Excel 2003 for PC

Hi,

Try selecting a cell and right click, Format cells, Font - Bold the text the way you want it to appear in that cell and then let it be the value you want to appear when you select that cell as a solution to a "What If" statement.

I build training spread sheets that let people generate pre-programmed answers to various data entries. Answers appear like magic.

Glad to be of assistance - please rate the posting - I can learn from you.

Try selecting a cell and right click, Format cells, Font - Bold the text the way you want it to appear in that cell and then let it be the value you want to appear when you select that cell as a solution to a "What If" statement.

I build training spread sheets that let people generate pre-programmed answers to various data entries. Answers appear like magic.

Glad to be of assistance - please rate the posting - I can learn from you.

Oct 26, 2008 | Microsoft Office 2003 Basic Edition...

Maybe this is what you need:

=IF(A1="toilet",(B1*2),(IF(A1="bread",(B1*3),(IF(A1="star",(B1*4))))))

this is called "nested".

You can put nested if function maximum 7. (for more than 7, we should make another "trick")

if you put toilet in A1 then come the value B1*2

if you put bread in A1 then come the value B1*3

if you put star in A1 then come the value B1*4

Note: SUM(F16*0.3) is wrong. should be only (F16*0.3) or if you want to do sum --> SUM(F16:F20)

=IF(A1="toilet",(B1*2),(IF(A1="bread",(B1*3),(IF(A1="star",(B1*4))))))

this is called "nested".

You can put nested if function maximum 7. (for more than 7, we should make another "trick")

if you put toilet in A1 then come the value B1*2

if you put bread in A1 then come the value B1*3

if you put star in A1 then come the value B1*4

Note: SUM(F16*0.3) is wrong. should be only (F16*0.3) or if you want to do sum --> SUM(F16:F20)

Apr 01, 2008 | Microsoft Office Professional 2007 Full...

Try using the SUMIF function for one condition or multiple conditions. Use the SUMIF worksheet function to create a total value for one range based on a value in another range. For example, for every cell in the rage B5:B25 that contains the value "Northwind", the following formula calculates the total for the corresponding cells in the range F5:F25. Formula:

=sumif(B5:B25,"Northwind",F5:F25)

Here are SUMIF functions for multiple conditions.

=sum(if((B5:B25="Northwind")*(C5:C25="Western"),F5:F25))

=sum(if((B5:B25="Northwind")+(C5:C25="Western"),F5:F25))

=sum(if(B5:B25="Northwind",IF(C5:C25="Western"),1,0)))

Also check your help for SUMIF functions.

If this helps you, Please rate me. Thanks, Patty

=sumif(B5:B25,"Northwind",F5:F25)

Here are SUMIF functions for multiple conditions.

=sum(if((B5:B25="Northwind")*(C5:C25="Western"),F5:F25))

=sum(if((B5:B25="Northwind")+(C5:C25="Western"),F5:F25))

=sum(if(B5:B25="Northwind",IF(C5:C25="Western"),1,0)))

Also check your help for SUMIF functions.

If this helps you, Please rate me. Thanks, Patty

Dec 09, 2007 | Business & Productivity Software

Is there by any chance a space or any other character before the equals sign? That could cause your formula to display as text.

Dec 03, 2007 | Microsoft Excel for PC

Apr 25, 2014 | Microsoft Office Standard for PC

51 people viewed this question

Usually answered in minutes!

×