Question about Computers & Internet

1 Answer

How to convert numericals in to words.

Dear Sir/Madam
For example   Column B50 = 5000.00
I want to put the formula to get the result in words  Five thousand
Which formulla i used?

Posted by imanuel on

Ad

1 Answer

Mike McWhinney

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 537 Answers

You will have to delve into some Visual Basic within Excel:

See this KB article from MS:

http://support.microsoft.com/kb/213360

Posted on Oct 31, 2007

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

All words in column A must be equal to column B plus the word on column H row 2...what is the formula? example: a2(dentist) h2(chico) on b2 must be "dentist chico"


You could use Concatenate command. Means to join together.
B2 = Concatenate A2, ,H2 Note the space in middle, for dentist chico. Otherwise will be dentistchico

Sep 15, 2011 | Microsoft Excel for PC

1 Answer

Write in words 12.0030, .00816, 3,009,010, 7,475.8, P5.0025


"Twelve point zero zero three zero", "point zero zero eight one six", "three million, nine thousand, ten", "seven thousand four hundred seventy-five point eight", "P five point zero zero two five".

These are not unique. The first one, for example, could also be written as "twelve point oh oh three oh".

Jul 12, 2011 | Office Equipment & Supplies

1 Answer

How to calculate the percentage using the excel



Hide All
Percentages are calculated by using the following equation:
amount/total = percentage
Where percentage is in decimal format.
What do you want to do?


Calculate the amount if you know the total and percentage For example, if you purchase a computer for $800 and there is an 8.9% sales tax, how much do you have to pay for the sales tax? In this example, you want to find 8.9% of 800.
Example The example may be easier to understand if you copy it to a blank worksheet.

  1. Create a blank workbook or worksheet.
  2. Select the example in the Help topic. Note Do not select the row or column headers.
    Selecting an example from Help
  3. Press CTRL+C.
  4. In the worksheet, select cell A1, and press CTRL+V.
  5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.
1 2 A B Purchase price Sales tax (in decimal form) 800 0.089 Formula Description (Result) =A2*B2 Multiplies 800 by 0.089 to find the amount of sales tax to pay ($71.20) Note To convert a number in percentage format to a decimal, divide it by 100. For example, the sales tax in this example (8.9) divided by 100 is .089.
Calculate the percentage if you know the total and amount For example, if you score 42 points correctly out of 50, what is the percentage of correct answers?
Example The example may be easier to understand if you copy it to a blank worksheet.
  1. Create a blank workbook or worksheet.
  2. Select the example in the Help topic. Note Do not select the row or column headers.
    Selecting an example from Help
  3. Press CTRL+C.
  4. In the worksheet, select cell A1, and press CTRL+V.
  5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.



Simple way Amount/Total*100

Apr 30, 2011 | Computers & Internet

3 Answers

How do i insert a formula in a column to add each number & give a total at the bottom?


For example, you have three numbers from A1 to A3. On row A4, type =SUM(A1:A3).

That should do it. :)

Sep 16, 2009 | Microsoft Office Excel 2007

2 Answers

I need a running balance in a column for a petty cash spreadsheet


In the first row of numbers, assume row 3 for example (leaving 2 rows for titles, put in cell E3: =C3+D3. In the next row (assuming row 4, put in cell E4: =C4+D4+E3. Use fill down to populate this formula all the way down.

Jun 18, 2009 | Microsoft Excel for PC

1 Answer

TROUBLE PROGRAMING A 20% DISCOUNT ON MY CASH REGISTER


You can solve these type of problems in Excel just write a formulla in another column for example you type the princple values in Column A & Row 1 and you write a formulla in colomn B & row 1 i.e., =SUM((A1-(A1*20%))). Then you will arrive the value after discount.

Dec 16, 2008 | Office Equipment & Supplies

2 Answers

Excel will not displaying the results of a trend array formula


Hi Griffnz,

Your "known Y's" or 'values' are in Column B. This is the first array in the Trend formula.

Your "known X's" or 'months' are in Column A. This is the second array in the trend formula.

The trend formula is supposed to give you a projection of what the rest of the values in Column B will be over the next few months (usually continuing cells in Column A). The cells you want these values to show up in represent the third array in the formula.

Thus, your formula should look more like: '=trend(B3:B14,A3:A14,A15:A18)'

However, your formula is leaving out The values in B and adding values from C - -- but there ARE no values in C. Apparently, C is where you want the values to appear. In that case, the C array would be the third array in your formula. This would look more like '=trend(B3:B14,A3:A14,C3:C14)

If this doesn't make sense, let me know.

Sep 30, 2008 | Microsoft Excel for PC

2 Answers

Help


go to page setup and under scaling you can adjust to your required percentage

Jul 22, 2008 | Microsoft Excel for PC

2 Answers

Display calculation result in a previous cell


Look into the =SUMIF function, it sounds like this may be what you are looking for.

Hope this helps!

Apr 09, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

163 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Marvin
Marvin

Level 3 Expert

85223 Answers

Brad Brown

Level 3 Expert

18193 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...