Posted by on

• Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that gotĀ 5 achievements.

Governor:

An expert whose answer gotĀ voted for 20 times.

Hot-Shot:

An expert who has answered 20 questions.

• Expert

Use mrexcel.com

Posted on Jan 09, 2009

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### What are the formulas in grading the grades uisng microsoft excel

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

1. All formulas begin with an equals sign (=).
2. Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division.
For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
3. Other formulas refer to different functions such as SUM, AVERAGE and others.
For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
4. Formulas can be combined with operands.
For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
5. Functions can be nested within each other.
For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

### Do you have a formula in Microsoft Excel that a value can convert to a word...(Ex. 15,000 then it will convert to in words fifteen Thousand..)thanks. need immediate reply.

Hi enelrah_mel0,

You can create a function called SpellNumber using the Visual Basic Editor in the Microsoft Excel to spell the number.

1. Please Open Microsoft Excel. Then press Alt + F11 to open the Visual Basic Editor.
2. Then, click "Insert" option above the Visual Basic Editor window and select "Module".
3. Then, in the Book1 Module1 (Code) window, paste the below code there. (pasted in the next post separately for your convenience)
4. Then, press Alt+Q to close the Visual Basic Editor window.
5. After that, please type the formula " =SpellNumber( * )" in the Excel Sheet and press the Enter Key.
6. Then, save the Excel Sheet.
eg: =SpellNumber(A1)

Where A1 is the first cell in the excel sheet.

Good Luck!

Please post back the result and let me know if you require further assistance.

Thanks for using Fixya.

Oct 29, 2010 | IBM ThinkPad T30 2366 Notebook

### Not able to scroll on my excel sheet

It's only in Excel you can't scroll? Can you scroll from side to side? If you have Excel 2003, try to press the "window" tab on the top and if the freeze pane is checked, uncheck it. Or if it says unfreeze pane, press that one. Hope this helps :)

Jul 20, 2009 | IBM ThinkPad T42 Notebook

### How to use vlookup in openoffice using different sheets

=VLOOKUP(A2;Sheet1.\$A\$3:D27;2;0)

The cell I created this formula in was Sheet 3 Cell C9 - to show the different sheets
A2 is the cell I want to look up
Sheet1.A3:D27 is the range of cells that contains the data I want to return, The first column relates directly to cell C9 is Sheet 3. I locked the first cell in my range as I wanted to apply the same formula across other cells hence the \$
2 is the number of the column that has the data I want to return, I had a choice in this formula of 4 columns
0 is the value to complete the formula

Feb 11, 2009 | Microsoft Excel for PC

### VLOOKUP FORMULA PROBLEM

VLOOKUP(A1,Sheet2A2:B20,2,FALSE)

The assumption here is A1 in Sheet 1 is the cell you want to reference, This cell can be pasted - Any problems let me know.

Jan 21, 2009 | Microsoft Excel for PC

### I need Excel's Furmula's

I found some excellent links to excel formulas for you:

This link lists excel formulas by category:

http://www.techonthenet.com/excel/formulas/

http://www.ozgrid.com/VBA/Functions.htm

Sep 20, 2008 | Microsoft Computers & Internet

### Excel formulas

type in "=" and then go to the cell in the 2nd sheet and click on the cell that contains the value you want carried to sheet 1. Then drag copy the forumula in sheet 1 to all the cells you want it to relate to. Now, if you place a value in e.g. A1 of sheet 2, then that same value will appear in A1 of sheet 1.
Good luck.

Sep 13, 2008 | Microsoft Computers & Internet

### How many formulas we can use at a time in Excel

That depends on which version of Excel you are using.
Excel 2003 supports up to 65,335 formulas
Excel 2007 has no limit.
you can communicate between the worksheets which are contained by one workbook (one excel-file).
Communicating between files cannot be done with formula's.

Apr 04, 2008 | Microsoft Excel for PC

## Open Questions:

#### Related Topics:

41 people viewed this question

Level 3 Expert

Level 3 Expert