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.
You can also reply to
An expert who has achieved level 2 by getting 100 points
An expert that got 5 achievements.
An expert who has written 3 tips or uploaded 2 video tips.
An expert whose answer got voted for 20 times.
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.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
#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.
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.
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.
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)
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: