Question about Microsoft Excel for PC

Ad

[G8]=IF(C8<0,G7,"")

Posted on Jun 02, 2008

Ad

Use the relative cell reference F4 key..

Posted on May 06, 2008

Ad

Hi,

A 6ya expert can help you resolve that 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.

The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).

click here to download the app (for users in the US for now) and get all the help you need.

Good luck!

Posted on Jan 02, 2017

Once you have copy the cell from where the formula cam from, on the destination cell,

go to

1. Edit

2. Paste Special

3. Formula.

4. Press Enter

This should resolve your problem. Regards.

go to

1. Edit

2. Paste Special

3. Formula.

4. Press Enter

This should resolve your problem. Regards.

Aug 11, 2010 | Microsoft Office Excel 2003 for PC

Correct a #N/A error
Show All
Hide All
This error occurs when a value is not available to a function or formula.

- Optionally, click the cell that displays the error, click the button that appears , and then click
**Show Calculation Steps**if it appears. - Review the following possible causes and solutions.
Missing data, and #N/A or NA() has been entered in its place

Replace #N/A with new data.

**Note**You can enter**#N/A**in those cells where data is not yet available. Formulas that refer to those cells will then return #N/A instead of attempting to calculate a value.

Giving an inappropriate value for the lookup_value argument in the HLOOKUP, LOOKUP, MATCH, or VLOOKUP worksheet function

Make sure that the lookup_value argument (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) is the correct type of value — for example, a value or a cell reference, but not a range reference. Using the VLOOKUP, HLOOKUP, or MATCH worksheet function to locate a value in an unsorted table

By default, functions that look up information in tables must be sorted in ascending order. However, the VLOOKUP and HLOOKUP worksheet functions contain a range_lookup argument (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) that instructs the function to find an exact match even if the table is not sorted. To find an exact match, set the range_lookup argument to FALSE. The MATCH worksheet function contains a match_type argument that specifies the order the list must be sorted in to find a match. If the function cannot find a match, try changing the match_type argument. To find an exact match, set the match_type argument to 0.

Using an argument in an array formula that is not the same number of rows or columns as the range that contains the array formula

If the array formula (array formula: A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. Array formulas are enclosed between braces { } and are entered by pressing CTRL+SHIFT+ENTER.) has been entered into multiple cells, make sure that the ranges referenced by the formula have the same number of rows and columns, or enter the array formula into fewer cells. For example, if the array formula has been entered into a range 15 rows high (C1:C15) and the formula refers to a range 10 rows high (A1:A10), the range C11:C15 will display #N/A. To correct this error, enter the formula into a smaller range (for example, C1:C10), or change the range to which the formula refers to the same number of rows (for example, A1:A15).

Omitting one or more required arguments from a built-in or custom worksheet function

Enter all arguments (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) in the function.

Using a custom worksheet function that is not available

Make sure that the workbook that contains the worksheet function is open and the function is working properly.

Running a macro that enters a function that returns #N/A

Make sure that the arguments (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) in the function are correct and in the correct position.

Oct 31, 2008 | Computers & Internet

Here's what you are looking for. Browse it and you can find it there all you want for shortcut keys. Follow this link below:

Microsoft Excel Shortcut keys

__Enter data by using shortcut keys____To____Press__

Complete a cell entryENTERCancel a cell entryESC**Repeat the last action****F4 or CTRL+Y****Start a new line in the same cell****ALT+ENTER**Delete the character to the left of the insertion point, or delete the selectionBACKSPACEDelete the character to the right of the insertion point, or delete the selectionDELETEDelete text to the end of the lineCTRL+DELETEMove one character up, down, left, or rightArrow keysMove to the beginning of the lineHOME**Edit a cell comment****SHIFT+F2****Create names from row and column labels****CTRL+SHIFT+F3****Fill down****CTRL+D****Fill to the right****CTRL+R****Fill the selected cell range with the current entry****CTRL+ENTER****Complete a cell entry and move down in the selection****ENTER****Complete a cell entry and move up in the selection****SHIFT+ENTER****Complete a cell entry and move to the right in the selection****TAB****Complete a cell entry and move to the left in the selection****SHIFT+TAB****Work in cells or the formula bar by using shortcut keys****To****Press****Start a formula****= (EQUAL SIGN)****Cancel an entry in the cell or formula bar****ESC****Edit the active cell****F2****Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents****BACKSPACE****Paste a name into a formula****F3****Define a name****CTRL+F3****Calculate all sheets in all open workbooks****F9 ****Calculate the active worksheet****SHIFT+F9****Insert the AutoSum formula****ALT+= (EQUAL SIGN)****Enter the date****CTRL+; (SEMICOLON)****Enter the time****CTRL+SHIFT+: (COLON)****Insert a hyperlink****CTRL+K****Complete a cell entry****ENTER****Copy the value from the cell above the active cell into the cell or the formula bar****CTRL+SHIFT+" (QUOTATION MARK)****Alternate between displaying cell values and displaying cell formulas****CTRL+` (SINGLE LEFT QUOTATION MARK)****Copy a formula from the cell above the active cell into the cell or the formula bar****CTRL+' (APOSTROPHE)****Enter a formula as an array formula****CTRL+SHIFT+ENTER****Display the Formula Palette after you type a valid function name in a formula****CTRL+A****Insert the argument names and parentheses for a function, after you type a valid function name in a formula****CTRL+SHIFT+A****Display the AutoComplete list****ALT+DOWN ARROW**

Microsoft Excel Shortcut keys

Complete a cell entryENTERCancel a cell entryESC

on Feb 11, 2011 | Computers & Internet

Yes,

That is Select the Cells which you want to SUM and Press**Alt+=**

This will bring the total just below the selected cells.

Thanks

Iqbal

- Select the column. (click on top of the column it will select)
- Right Click and select Format Cells.
- Select
**Currency**in**Category**then press**OK**

That is Select the Cells which you want to SUM and Press

This will bring the total just below the selected cells.

Thanks

Iqbal

Apr 02, 2008 | Computers & Internet

This is a long shot ... I dont know what spread sheet you are having trouble with. It might be that your sheet thinks you are entering text when you put in the reference "J~" Be dure you are entering a formuila and not test that looks like a formula (to you)

Sep 14, 2009 | Computers & Internet

Enter data the number 10 on cell A1. Enter data the number 20 on cell B2. Mouse click on cell C3. Press equal sign, press left arrow, press *, press left arrow twice, press enter. Mouse click on cell C3. You'll see your formula on the address bar. Hope this helps.

Mar 06, 2009 | Microsoft Office Excel 2003 for PC

Step1. Start Microsoft Excel and open the file you want to change.
Step2. Double-click on the cell where you want the total to appear.
Step3. Press the = key on the keyboard. This tells Excel that you are entering a formula into the cell.
Step4. Enter the formula, then press Enter. Follow the steps below for an example.
Step5. Enter an opening parenthesis character: (.
Step6. Enter a cell name. For example: =(E2.
Step7. Press the + key.
Step8. Enter another cell name and a closing parenthesis character: ). For example: =(E2+E3).
Step9. Enter a minus sign and a third cell name. For example: =(E2+E3)-E4.
Step10. Press the Enter key to accept the formula. The cell will display the sum of the first two cells minus the third cell.
$('.Article .Steps .Image').each(function(i,e){
e = $(e);
e.find('img').error(function(){
$(this).unbind();
e.remove();
});
});

Tips & Warnings

Tips & Warnings

- Formulas are just equations. Instead of adding or subtracting numbers you are adding and subtracting the contents of a cell.
- Excel includes a number of predefined functions to use as well. You can combine the predefined functions into your own formula. (See "How to Use Provided Excel Formulas.")

Dec 03, 2008 | Microsoft Office Professional 2007 Full...

Nope, sorry, although I am truly an expert at Excel formulas, I do not understand what you are trying to end up with in the final cell. We can compare a specified field with two spreadsheets - use named ranges and index/match lookup formulas. But then where you really lose me is in reading "a generic field" to find a match, and then placing what "data from another field" into what "other sheet" - ? See the confusion?

Best way to compare 2 given parameters would be to use a nested if formula, with index/match combo. Here is a simple Excel example of how such a formula could be structured:

Sample Data (columnar arangement):

A1: Part B1: Code C1: Price D1: Find Part E1: Find Code

A2: x B2: 11 C2: 5.00 D2: y E2: 12

A3: x B3: 12 C3: 6.00 D3: y E3: 11

A4: y B4: 11 C4: 7.00 D4: x E4: 12

A5: y B5: 12 C5: 8.00 D5: x E5: 11

To retrieve the price for part y with code 12 and return the value to cell F2, type the following formula in cell F2:

=INDEX($C$2:$C$5,MATCH(D2,IF($B$2:$B$5=E2,$A$2:$A$5),0))

Press CTRL+SHIFT+ENTER to enter the formula as an array formula. The formula returns the value 8.00.

To take this one step further, with range names, this example will find one value at a specified location which matches a specific row header value and column header value. Let's say the range is home values (Range=HomeVal), Column A of HomeVal contains street addresses,"row headers" (Range=StAddress), and Row 1 contains dates of the various values that are in the body of the table, "column headers" (Range=Dates). To return the specific value from the range HomeVal to another sheet, where A1=address specified and A2=date specified:

=INDEX(HomeVal,(MATCH($A$1,StAddress,0)),(MATCH($A$2,Dates,0)))

Then make sure to press CTRL+SHIFT+ENTER to enter the formula as an array formula - if you only hit enter, these types of formulas will not work properly.

Please post back if you need further help, with more details, otherwise thank you for using and rating FixYa!

Best way to compare 2 given parameters would be to use a nested if formula, with index/match combo. Here is a simple Excel example of how such a formula could be structured:

Sample Data (columnar arangement):

A1: Part B1: Code C1: Price D1: Find Part E1: Find Code

A2: x B2: 11 C2: 5.00 D2: y E2: 12

A3: x B3: 12 C3: 6.00 D3: y E3: 11

A4: y B4: 11 C4: 7.00 D4: x E4: 12

A5: y B5: 12 C5: 8.00 D5: x E5: 11

To retrieve the price for part y with code 12 and return the value to cell F2, type the following formula in cell F2:

=INDEX($C$2:$C$5,MATCH(D2,IF($B$2:$B$5=E2,$A$2:$A$5),0))

Press CTRL+SHIFT+ENTER to enter the formula as an array formula. The formula returns the value 8.00.

To take this one step further, with range names, this example will find one value at a specified location which matches a specific row header value and column header value. Let's say the range is home values (Range=HomeVal), Column A of HomeVal contains street addresses,"row headers" (Range=StAddress), and Row 1 contains dates of the various values that are in the body of the table, "column headers" (Range=Dates). To return the specific value from the range HomeVal to another sheet, where A1=address specified and A2=date specified:

=INDEX(HomeVal,(MATCH($A$1,StAddress,0)),(MATCH($A$2,Dates,0)))

Then make sure to press CTRL+SHIFT+ENTER to enter the formula as an array formula - if you only hit enter, these types of formulas will not work properly.

Please post back if you need further help, with more details, otherwise thank you for using and rating FixYa!

Jul 08, 2008 | Microsoft Computers & Internet

at first select the 1st page data and select data-subtotal from the upper menu list.

then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.

thanks

then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.

thanks

Dec 04, 2007 | Microsoft Excel for PC

Dear Madiha35,

I would recommend the use of the Table Function in Excel.

Here are the steps in Excel 2007, if this does not work for your version please add comment for me to reply to.

Conversely, If you would like the softcopy of the screenshots, I would be happy to email them to you.

Step 1: Enter your data into the worksheet.

Step 2: Create Table

Highlight the relevant data

On the insert tab, click on Table

Step 3: Verify Table range is correct, Click OK

Step 4: Select the cell you where you wish to Sum Data.

Click on Autosum.

Step 5: To Insert new data

Click on the sum row in the table, (Not the entire worksheet row)

Right click, Insert, Insert Table rows from above

Step 6: Enter new data in row

Step 7: Data is automatically calculated in formula.

Oct 22, 2007 | Computers & Internet

Jan 28, 2016 | Microsoft Excel for PC

Dec 12, 2013 | Microsoft Excel for PC

Jul 23, 2013 | Microsoft Excel for PC

182 people viewed this question

Usually answered in minutes!

I'm copying formulas but the answers stay the same

×