Question about Business & Productivity Software

How to check if the value of your formula is correct?

Go to control panel hit systems,click the hardwear tab,devices and u can click on the programs and run a scan to see if somethings wrong

Posted on Mar 03, 2008

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

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 | Business & Productivity Software

Make sure, when you entr a formula that you hit the ENTER key instead of just moving to tyour next cell. To have all numbers added or moved, use the"Special" application, or change the value. Such as -if you are working in text mode and you enter numbers, they are only numbers in text mode. They don't have a value. Correct the cells to reflect numbers. Right click, format cell - select what you want.

Nov 05, 2009 | Microsoft Office Excel 2003 for PC

Try this. If any of the cells are zero (or blank), the word 'zero' will be displayed. Substitute anything you want for the text including blank ""

=IF(OR(F61=0,J61=0,N61=0),"zero",AVERAGE(F61,J61,N61))

=IF(OR(F61=0,J61=0,N61=0),"zero",AVERAGE(F61,J61,N61))

Aug 26, 2009 | Microsoft Office Excel 2007

#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

what is the formula

May 19, 2009 | Microsoft Excel for PC

Clicking cancel will invalidate the formulae, circular references refer to the dependant and precedent cells using each other.

Track/ Audit depending on your Excel version to show which formulae is incorrect - or options view, tick show formaulae and remove them.

Track/ Audit depending on your Excel version to show which formulae is incorrect - or options view, tick show formaulae and remove them.

Nov 20, 2008 | Microsoft Excel for PC

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 Business & Productivity Software

Suggest you do some debugging in steps:

1. Open the 'bills up to 022908.xls'

2. Use an empty cell to "=CONCATENATE(D3,L3)". That way you can see what values are being generated.

3. Copy the values of that cell and see if you can find them in Col G of 'bills up to 022908.xls'.

Once its broken down into pieces you can usually see "the error of your ways."

Hope this helps.

1. Open the 'bills up to 022908.xls'

2. Use an empty cell to "=CONCATENATE(D3,L3)". That way you can see what values are being generated.

3. Copy the values of that cell and see if you can find them in Col G of 'bills up to 022908.xls'.

Once its broken down into pieces you can usually see "the error of your ways."

Hope this helps.

Mar 09, 2008 | Microsoft Excel for PC

The problem doesn't say this explicitly, but it looks like you're using Excel. This answer depends on that assumption being correct.

Are you saying that some of your inputs are blank? And LOOKUP fails to map them to 0? Or are you saying that some of your values come back from LOOKUP as blanks? (They shouldn't; lookup should return either a value from the lookup table or an error.) Or is it the case that some input values get mapped to blank by your LOOKUP function?

Assuming that you're getting blanks back from LOOKUP where you wanted zeros -- for whatever reason -- here is something you can try.

It looks like the value you're looking up is in cell A3. Let's say your formula (the result of the LOOKUP) is in B3. In C3, you can put the formula =IF(ISBLANK(A3), 0, A3). This function tests if A3 is blank. If it is, it returns a 0. If it's not, you get A3 again. (But A3 has to really be blank -- spaces will count as non-blank.)

Then, you can copy data out of column C instead of column B, and it should have zeros in place of blanks.

Are you saying that some of your inputs are blank? And LOOKUP fails to map them to 0? Or are you saying that some of your values come back from LOOKUP as blanks? (They shouldn't; lookup should return either a value from the lookup table or an error.) Or is it the case that some input values get mapped to blank by your LOOKUP function?

Assuming that you're getting blanks back from LOOKUP where you wanted zeros -- for whatever reason -- here is something you can try.

It looks like the value you're looking up is in cell A3. Let's say your formula (the result of the LOOKUP) is in B3. In C3, you can put the formula =IF(ISBLANK(A3), 0, A3). This function tests if A3 is blank. If it is, it returns a 0. If it's not, you get A3 again. (But A3 has to really be blank -- spaces will count as non-blank.)

Then, you can copy data out of column C instead of column B, and it should have zeros in place of blanks.

Jan 05, 2008 | Business & Productivity Software

Nov 29, 2016 | Toshiba Business & Productivity Software

26 people viewed this question

Usually answered in minutes!

×