Using Excel, in one formula, how do I reference a cell used in another formula in a different cell?
Q. For example: One cell is this formula: =MID(A12,14,99) Another cell is this formula: =IF(A12>0,"Y","N") How do I make it to where whatever cell reference I used in the "MID" formula (A12 in my example) is automatically reflected in the "IF" formula? If I type in C23 in the "MID" formula, I want the "IF" formula to automatically change to C23 to coincide with the "MID" formula. For example: One cell is this formula: =MID(A12,14,99) Another cell is this formula: =IF(A12>0,"Y","N") How do I make it to where whatever cell reference I used in the "MID" formula (A12 in my example) is automatically reflected in the "IF" formula? If I type in C23 in the "MID" formula, I want the "IF" formula to automatically change to C23 to coincide with the… [cont.]
Asked by El Mariachi - Wed May 2 13:10:35 2007 - - 2 Answers - 0 Comments
A. ok 2 ways to do this. one in another cell, lets say b1 you type in =a12 then change your 2 formulas to say =mid(b1...) =if(b1...) then all you have to do is change b1 and the formulas will never change but will always be looking at the same data together. you could then create a macro to automatically change the value of b1. the other way is to cut and paste. put the formulas side by side rather than one over another. then when you copy and paste, the "a12" will change in both formulas to match the next cell.
Answered by Audacity Pro - Thu May 3 00:59:24 2007
Q. For example: One cell is this formula: =MID(A12,14,99) Another cell is this formula: =IF(A12>0,"Y","N") How do I make it to where whatever cell reference I used in the "MID" formula (A12 in my example) is automatically reflected in the "IF" formula? If I type in C23 in the "MID" formula, I want the "IF" formula to automatically change to C23 to coincide with the "MID" formula. For example: One cell is this formula: =MID(A12,14,99) Another cell is this formula: =IF(A12>0,"Y","N") How do I make it to where whatever cell reference I used in the "MID" formula (A12 in my example) is automatically reflected in the "IF" formula? If I type in C23 in the "MID" formula, I want the "IF" formula to automatically change to C23 to coincide with the… [cont.]
Asked by El Mariachi - Wed May 2 13:10:35 2007 - - 2 Answers - 0 Comments
A. ok 2 ways to do this. one in another cell, lets say b1 you type in =a12 then change your 2 formulas to say =mid(b1...) =if(b1...) then all you have to do is change b1 and the formulas will never change but will always be looking at the same data together. you could then create a macro to automatically change the value of b1. the other way is to cut and paste. put the formulas side by side rather than one over another. then when you copy and paste, the "a12" will change in both formulas to match the next cell.
Answered by Audacity Pro - Thu May 3 00:59:24 2007
Microsoft Excel- How to reference a cell in the "previous" worksheet?
Q. How do I create a formula that will reference a cell in the "previous" worksheet, so that when I copy that formula onto subsequent worksheets, it references that cell in the worksheet immediately before it (and not the original cell.)? For example, I want a formula in worksheet 3 that will reference cell A1 on worksheet 2. And then in worksheet 4 reference cell A1 on worksheet 3. I hope that's clear, and thanks for your help! I would like to be able to copy and paste the worksheet onto additional worksheets and have the formula remain intact. I understand how to create this fomula on EACH worksheet, I need to know how to create a formula that can be "cut-and-paste" and will be applied to all the future formulas. ctf- Actually, I just… [cont.]
Asked by CFrehner - Wed Sep 26 15:14:25 2007 - - 4 Answers - 2 Comments
A. If your worksheet names have a pattern to them, it may be doable with a formula. For example, if you have Sheet 1, then Sheet 2, etc., the formula below will find the sheet name, subtract one from the number at the end to get the previous sheet name, and then get the value from there. Putting this formula in Sheet 2 will get the contents of 'Sheet 1'!A1: =INDIRECT("'Sheet "& VALUE(RIGHT( MID(CELL("filename"), SEARCH("]", CELL("filename"))+1,256), 2)) -1 &"'!A1") I don't know how much trouble you want to go to to automate this, but if there is no easy pattern, you could put all the sheet names in a table and have the formula look up the previous sheet name by first looking up the current sheet name, using a formula similar to the one… [cont.]
Answered by aladou - Wed Sep 26 16:03:42 2007
Q. How do I create a formula that will reference a cell in the "previous" worksheet, so that when I copy that formula onto subsequent worksheets, it references that cell in the worksheet immediately before it (and not the original cell.)? For example, I want a formula in worksheet 3 that will reference cell A1 on worksheet 2. And then in worksheet 4 reference cell A1 on worksheet 3. I hope that's clear, and thanks for your help! I would like to be able to copy and paste the worksheet onto additional worksheets and have the formula remain intact. I understand how to create this fomula on EACH worksheet, I need to know how to create a formula that can be "cut-and-paste" and will be applied to all the future formulas. ctf- Actually, I just… [cont.]
Asked by CFrehner - Wed Sep 26 15:14:25 2007 - - 4 Answers - 2 Comments
A. If your worksheet names have a pattern to them, it may be doable with a formula. For example, if you have Sheet 1, then Sheet 2, etc., the formula below will find the sheet name, subtract one from the number at the end to get the previous sheet name, and then get the value from there. Putting this formula in Sheet 2 will get the contents of 'Sheet 1'!A1: =INDIRECT("'Sheet "& VALUE(RIGHT( MID(CELL("filename"), SEARCH("]", CELL("filename"))+1,256), 2)) -1 &"'!A1") I don't know how much trouble you want to go to to automate this, but if there is no easy pattern, you could put all the sheet names in a table and have the formula look up the previous sheet name by first looking up the current sheet name, using a formula similar to the one… [cont.]
Answered by aladou - Wed Sep 26 16:03:42 2007
In MS Excel, how do I reference a cell's color if it has been set by a conditional format?
Q. I have an Excel spreadsheet that has a few columns with conditional formatting. If there is an error (as determined by a conditional format) in any of the cells they turn red. I want to be able to reference the color of the cell as it's displayed, not as it's initially set before the conditional format. I have tried using c.Interior.ColorIndex however this just gives me the initial color of the cell. Any ideas?
Asked by Chocoholic - Tue Jun 2 23:27:31 2009 - - 1 Answers - 0 Comments
A. There are two ways (maybe more) you could do this... Instead of checking for the interior color set by the conditional formatting, you could code to check for the same condition e.g. if cell B1 has a conditional format to turn red if it has an error value If WorksheetFunction.IsError (Range("B1")) Then MsgBox "Interior color is red." Else MsgBox "Interior color is not red." End If The other way is to check which Conditional Formatting condition is true (if any). Here is a site that gives you code to determine what condition is true and it also shows you how to get the color of that condition.
Answered by Cozmosis - Wed Jun 3 09:50:06 2009
Q. I have an Excel spreadsheet that has a few columns with conditional formatting. If there is an error (as determined by a conditional format) in any of the cells they turn red. I want to be able to reference the color of the cell as it's displayed, not as it's initially set before the conditional format. I have tried using c.Interior.ColorIndex however this just gives me the initial color of the cell. Any ideas?
Asked by Chocoholic - Tue Jun 2 23:27:31 2009 - - 1 Answers - 0 Comments
A. There are two ways (maybe more) you could do this... Instead of checking for the interior color set by the conditional formatting, you could code to check for the same condition e.g. if cell B1 has a conditional format to turn red if it has an error value If WorksheetFunction.IsError (Range("B1")) Then MsgBox "Interior color is red." Else MsgBox "Interior color is not red." End If The other way is to check which Conditional Formatting condition is true (if any). Here is a site that gives you code to determine what condition is true and it also shows you how to get the color of that condition.
Answered by Cozmosis - Wed Jun 3 09:50:06 2009
In spreadsheet applications, what is the difference between "Cell Address" and "Cell Reference"?
Q. I find the words "address" and "reference" being used to refer to a cell in a sheet/worksheet. What exactly is the difference between the 2. Can these terms be used interchangebly?
Asked by mad g - Wed Aug 30 05:50:13 2006 - - 1 Answers - 0 Comments
A. Mad g don't lose your marble here is your link. Find out
Answered by Joe_Young - Wed Aug 30 05:55:31 2006
Q. I find the words "address" and "reference" being used to refer to a cell in a sheet/worksheet. What exactly is the difference between the 2. Can these terms be used interchangebly?
Asked by mad g - Wed Aug 30 05:50:13 2006 - - 1 Answers - 0 Comments
A. Mad g don't lose your marble here is your link. Find out
Answered by Joe_Young - Wed Aug 30 05:55:31 2006
WhatHow to do a Cell reference on a pivot table in Excel 2007 . would you like to ask?
Q. How do you take the information from a pivot table and references the data into another cell in a different sheet? I can get it to work for the name but not the total.
Asked by Steve C - Thu Feb 12 13:50:12 2009 - - 1 Answers - 0 Comments
A. You need to use the function getpivotdata use your excel help, sometimes is not easy to understand, so keep reading: easy way to use getpivotdata function: 1.- Make sure you have enable the Generate GetPivotData, to do this: Click the Microsoft Office Button, click Excel Options, and then click the Formulas tab. . Make sure that the Use GetPivotData functions for PivotTable references check box is selected (under Working with formulas), and then click OK. 2.- Reference the cell: Select a cell outside the PivotTable range (in the same worksheet or other worksheet). Type an equal sign. Go to your PivotTable and select the cell that contains the value that you want to reference. For example, if the value is in cell C3, select C3. … [cont.]
Answered by gospieler - Thu Feb 12 15:00:50 2009
Q. How do you take the information from a pivot table and references the data into another cell in a different sheet? I can get it to work for the name but not the total.
Asked by Steve C - Thu Feb 12 13:50:12 2009 - - 1 Answers - 0 Comments
A. You need to use the function getpivotdata use your excel help, sometimes is not easy to understand, so keep reading: easy way to use getpivotdata function: 1.- Make sure you have enable the Generate GetPivotData, to do this: Click the Microsoft Office Button, click Excel Options, and then click the Formulas tab. . Make sure that the Use GetPivotData functions for PivotTable references check box is selected (under Working with formulas), and then click OK. 2.- Reference the cell: Select a cell outside the PivotTable range (in the same worksheet or other worksheet). Type an equal sign. Go to your PivotTable and select the cell that contains the value that you want to reference. For example, if the value is in cell C3, select C3. … [cont.]
Answered by gospieler - Thu Feb 12 15:00:50 2009
Describe the difference between an absolute cell reference and a relative cell reference in a spreadsheet?
Q. computer basic question
Asked by Sharmila V - Thu Feb 19 17:35:08 2009 - - 1 Answers - 1 Comments
A. a cell reference is when an excel formula uses data from a different cell (looks something like A4) to calculate. relative cell reference- this means that as you copy or fill the formula down a column, the cell reference will change relative to its original position. so the A4 will change to A5 as you fill down. absolute cell reference- this means that as you copy or fill the formula down a column, the cell reference will always stayu the same. this is represented by $ symbols that make excel know you want an absolute reference. so the A4 will look like $A$4 and as you copy&paste down, the cell refence will never change. hope that helps.
Answered by expletive_xom - Sun Feb 22 13:51:42 2009
Q. computer basic question
Asked by Sharmila V - Thu Feb 19 17:35:08 2009 - - 1 Answers - 1 Comments
A. a cell reference is when an excel formula uses data from a different cell (looks something like A4) to calculate. relative cell reference- this means that as you copy or fill the formula down a column, the cell reference will change relative to its original position. so the A4 will change to A5 as you fill down. absolute cell reference- this means that as you copy or fill the formula down a column, the cell reference will always stayu the same. this is represented by $ symbols that make excel know you want an absolute reference. so the A4 will look like $A$4 and as you copy&paste down, the cell refence will never change. hope that helps.
Answered by expletive_xom - Sun Feb 22 13:51:42 2009
The cell reference display in "excel" has changed from letters across the top and numbers down the side?
Q. I now have numbers running left to right and top to bottom. how do I fix this?
Asked by cantgybe - Mon May 11 07:55:55 2009 - - 2 Answers - 0 Comments
A. Go to the TOOLS menu and select OPTIONS... Now go to the General tab of the Options dialog window and set the R1C1 Reference Style to being un-checked. Then click the OK button.
Answered by unknown - Mon May 11 08:03:46 2009
Q. I now have numbers running left to right and top to bottom. how do I fix this?
Asked by cantgybe - Mon May 11 07:55:55 2009 - - 2 Answers - 0 Comments
A. Go to the TOOLS menu and select OPTIONS... Now go to the General tab of the Options dialog window and set the R1C1 Reference Style to being un-checked. Then click the OK button.
Answered by unknown - Mon May 11 08:03:46 2009
How do i reference the address that is a value in a cell in a formula in another cell in Excel.?
Q. I have used a formula to construct a piece of text that looks like an address eg $C$1 in cell A1. I now want to use that value as an address in a formula in cell F1 eg I would like the value stored in $C$1 to appear in cell F1 by referencing A1. I do not know before hand that A1 has $C$1 in it since, depending on other variables, A1 might evaluate to some other piece of text that is a different address.
Asked by wvl - Thu Mar 9 17:11:12 2006 - - 1 Answers - 0 Comments
A. This is called an indirect reference =indirect(a1) in cell F1 equals whats in c1 when a1=$c$1
Answered by wwpowell_ga - Thu Mar 9 17:25:59 2006
Q. I have used a formula to construct a piece of text that looks like an address eg $C$1 in cell A1. I now want to use that value as an address in a formula in cell F1 eg I would like the value stored in $C$1 to appear in cell F1 by referencing A1. I do not know before hand that A1 has $C$1 in it since, depending on other variables, A1 might evaluate to some other piece of text that is a different address.
Asked by wvl - Thu Mar 9 17:11:12 2006 - - 1 Answers - 0 Comments
A. This is called an indirect reference =indirect(a1) in cell F1 equals whats in c1 when a1=$c$1
Answered by wwpowell_ga - Thu Mar 9 17:25:59 2006
How can i get a formula to use the same cell reference but for different worksheets?
Q. eg. sum of Sheet 1 C6 to Sheet 5 C6?
Asked by nickinoo - Mon Jun 22 07:00:35 2009 - - 2 Answers - 0 Comments
A. =SUM(Sheet1:Sheet5!C6)
Answered by bomb #21 - Mon Jun 22 11:24:01 2009
Q. eg. sum of Sheet 1 C6 to Sheet 5 C6?
Asked by nickinoo - Mon Jun 22 07:00:35 2009 - - 2 Answers - 0 Comments
A. =SUM(Sheet1:Sheet5!C6)
Answered by bomb #21 - Mon Jun 22 11:24:01 2009
I need help with Excel, I want to reference a cell from a different worksheet.?
Q. I have two worksheets in a single Excel file. I would like to include the sum of the values in sheet#1 as a precedent in sheet#2. This has to be simple, but I can't make it happen. I checked the help section, which mentions the capability to use values from different sheets, but it does not describe how. I have also tried all of the Paste-Special features to no avail. It's important to mention that I want the precedent in sheet#2 to update automatically whenever the referenced cell in sheet#1 is changed. Thanks!
Asked by chemicalburn2003 - Thu Dec 28 12:54:42 2006 - - 3 Answers - 0 Comments
A. just reference the sheet name, followed by the cell(s) on that sheet that you would like to have in any cell - like this: =Sheet1!A1 you can also do this by typing an = in the cell, then using your mouse to to go the sheet and cell(s) you want to link to, then press enter. this will create the formula without you typing it manually. you can also create links to sheets and cells in other workbooks this way, although the link is not updated automatically as it is when you reference cells and sheets in the same workbook.
Answered by piquet - Thu Dec 28 12:59:40 2006
Q. I have two worksheets in a single Excel file. I would like to include the sum of the values in sheet#1 as a precedent in sheet#2. This has to be simple, but I can't make it happen. I checked the help section, which mentions the capability to use values from different sheets, but it does not describe how. I have also tried all of the Paste-Special features to no avail. It's important to mention that I want the precedent in sheet#2 to update automatically whenever the referenced cell in sheet#1 is changed. Thanks!
Asked by chemicalburn2003 - Thu Dec 28 12:54:42 2006 - - 3 Answers - 0 Comments
A. just reference the sheet name, followed by the cell(s) on that sheet that you would like to have in any cell - like this: =Sheet1!A1 you can also do this by typing an = in the cell, then using your mouse to to go the sheet and cell(s) you want to link to, then press enter. this will create the formula without you typing it manually. you can also create links to sheets and cells in other workbooks this way, although the link is not updated automatically as it is when you reference cells and sheets in the same workbook.
Answered by piquet - Thu Dec 28 12:59:40 2006
What is a $ stands for in a cell reference in excel?
Q. What is a $ stands for in a cell reference in excel?
Asked by rainee - Thu May 11 12:39:43 2006 - - 5 Answers - 0 Comments
A. When you copy cells with formulas in them, Excel changes the the formula to make a guess as to what your new formula references should be. However there are cases in which you do not what Excel to change a cell reference. By putting the $ in front of the column or row reference Excel will not change it when copying. For Example: A1 contains 10. B1 through B10 contains a series of the values 1 to 10. In C1 you create the formula =A1*B1. Now you want to copy this formula down 9 more times to multiply 10 times each number but when you do the copy, Excel automatically changes the formulas and such: A2*B2, A3*B3, etc. So to keep A1 in the formula all the way down. Make your formula =A$1*B1 (F4 key toggles this). Then when you copy the… [cont.]
Answered by flipdanielpa - Thu May 11 12:54:27 2006
Q. What is a $ stands for in a cell reference in excel?
Asked by rainee - Thu May 11 12:39:43 2006 - - 5 Answers - 0 Comments
A. When you copy cells with formulas in them, Excel changes the the formula to make a guess as to what your new formula references should be. However there are cases in which you do not what Excel to change a cell reference. By putting the $ in front of the column or row reference Excel will not change it when copying. For Example: A1 contains 10. B1 through B10 contains a series of the values 1 to 10. In C1 you create the formula =A1*B1. Now you want to copy this formula down 9 more times to multiply 10 times each number but when you do the copy, Excel automatically changes the formulas and such: A2*B2, A3*B3, etc. So to keep A1 in the formula all the way down. Make your formula =A$1*B1 (F4 key toggles this). Then when you copy the… [cont.]
Answered by flipdanielpa - Thu May 11 12:54:27 2006
I want to multiply a cell by another cell ( fixed cell reference) how?
Q. So I have numbers in cells C2 to C10 and I want to multiply these cells by another cell. So if I have a number in E10. So when I drag my cursor from C2 to C10 they will all be multiplied by E10.
Asked by jbrown0193 - Wed Nov 12 13:19:28 2008 - - 1 Answers - 0 Comments
A. you cant do it the way you want, what you need to do is put the following in D2 C2*$E$10 and drag across to D10, your answers will be in the D row, you cant do anything on a cell and have the answer in the same cell as the initial number (if that makes sense)
Answered by Glentoran_FC - Wed Nov 12 13:24:17 2008
Q. So I have numbers in cells C2 to C10 and I want to multiply these cells by another cell. So if I have a number in E10. So when I drag my cursor from C2 to C10 they will all be multiplied by E10.
Asked by jbrown0193 - Wed Nov 12 13:19:28 2008 - - 1 Answers - 0 Comments
A. you cant do it the way you want, what you need to do is put the following in D2 C2*$E$10 and drag across to D10, your answers will be in the D row, you cant do anything on a cell and have the answer in the same cell as the initial number (if that makes sense)
Answered by Glentoran_FC - Wed Nov 12 13:24:17 2008
what is the definition of cell value, cell reference, formula, grid lines, & work book??
Q. it is all about microsoft excel, spreadsheet. please further elaborate or specify your answer. :)
Asked by D.M.C.L. - Sat Sep 15 04:24:52 2007 - - 2 Answers - 0 Comments
A. A cell Value is the current contents of the cell such as Cell A1's value is "ABC" which brings me to a cell reference. A:1 means Column A :row 1 this is the cell's reference. you can call a cell by value or by reference. calling by value returns the current value of the cell. Calling by reference will return whatever is in the cell at the point you reference it. Similar I know, but can be useful. grid lines are the lines which separate each cell these can be modified in a vast many ways. An excel spreadsheet is broken up into three sheets by default sheet1,2,3. The workboook consists of all the sheets. you can search by sheet or by workbook. searching by sheet searches on the current page in view. searching by workbooks will search… [cont.]
Answered by manbearpig - Sat Sep 15 04:36:56 2007
Q. it is all about microsoft excel, spreadsheet. please further elaborate or specify your answer. :)
Asked by D.M.C.L. - Sat Sep 15 04:24:52 2007 - - 2 Answers - 0 Comments
A. A cell Value is the current contents of the cell such as Cell A1's value is "ABC" which brings me to a cell reference. A:1 means Column A :row 1 this is the cell's reference. you can call a cell by value or by reference. calling by value returns the current value of the cell. Calling by reference will return whatever is in the cell at the point you reference it. Similar I know, but can be useful. grid lines are the lines which separate each cell these can be modified in a vast many ways. An excel spreadsheet is broken up into three sheets by default sheet1,2,3. The workboook consists of all the sheets. you can search by sheet or by workbook. searching by sheet searches on the current page in view. searching by workbooks will search… [cont.]
Answered by manbearpig - Sat Sep 15 04:36:56 2007
How would you explain sick cell anemia with reference to base substitution?
Q. Thanks, I'm having difficulty understanding what happens during the transcription, translation process. Thank you so much Asst Prof, you had the points and keywords I was looking for in the answer! Thanks.
Asked by Carrie - Mon Sep 14 08:37:17 2009 - - 1 Answers - 0 Comments
A. The gene for the beta-chain of hemoglobin in found on chromosome #11. It codes for a polypeptifde 287 amino acids long, in which the 6th is normally glutamic acid. But in HbS, the 6th amino acid is valine. This is because there has been a base substitution in the middle base of the triplet- GTG instead of GAG. This is enough to place the wrong amino acid in the polypeptide.
Answered by Asst Prof - Mon Sep 14 09:14:28 2009
Q. Thanks, I'm having difficulty understanding what happens during the transcription, translation process. Thank you so much Asst Prof, you had the points and keywords I was looking for in the answer! Thanks.
Asked by Carrie - Mon Sep 14 08:37:17 2009 - - 1 Answers - 0 Comments
A. The gene for the beta-chain of hemoglobin in found on chromosome #11. It codes for a polypeptifde 287 amino acids long, in which the 6th is normally glutamic acid. But in HbS, the 6th amino acid is valine. This is because there has been a base substitution in the middle base of the triplet- GTG instead of GAG. This is enough to place the wrong amino acid in the polypeptide.
Answered by Asst Prof - Mon Sep 14 09:14:28 2009
MS Excel cell reference hiding function?
Q. I need a formula to hide this function in a cell, when there is no value ( #REF!, #N/A ).But I want result to appear for those reference, if there is a numeric or text value.
Asked by saba - Sun Jan 6 12:08:14 2008 - - 4 Answers - 0 Comments
A. To hide error value in cell, use "ISERROR" function to hide #REF!,#N/A Example: =IF(ISERROR(LOOKUP(A10,B1 4,C15)),"", lookup(A10,B14,C15))
Answered by sarvy - Mon Jan 7 12:32:38 2008
Q. I need a formula to hide this function in a cell, when there is no value ( #REF!, #N/A ).But I want result to appear for those reference, if there is a numeric or text value.
Asked by saba - Sun Jan 6 12:08:14 2008 - - 4 Answers - 0 Comments
A. To hide error value in cell, use "ISERROR" function to hide #REF!,#N/A Example: =IF(ISERROR(LOOKUP(A10,B1 4,C15)),"", lookup(A10,B14,C15))
Answered by sarvy - Mon Jan 7 12:32:38 2008
Excel referencing question: Can you reference a cell using a formula? What I mean is..?
Q. So for instance, lets say I want B2 to be equal to cell A4 (this example is simplified so just bare with this example), and I want to do it by letting B2 be equal to A(2*2). Can i do this? Can i reference a cell and multiply the referenced cell row by a number or function? Just restating question
Asked by lupus - Wed Jul 23 16:03:21 2008 - - 3 Answers - 0 Comments
A. Try this formula in B2 =INDIRECT("A" & 2*2) if other cells are involved say, B3 = 2 , B4 = 2, =INDIRECT("A" & B3*B4) Then the formula will get you the value from A4 from the above formulas Want to deal with the column as well? try this =INDIRECT(ADDRESS(2*2, 1)) OR =INDIRECT(ADDRESS( B3*B4, 1)) Hope this helps.
Answered by AQuestionMark - Wed Jul 23 22:33:17 2008
Q. So for instance, lets say I want B2 to be equal to cell A4 (this example is simplified so just bare with this example), and I want to do it by letting B2 be equal to A(2*2). Can i do this? Can i reference a cell and multiply the referenced cell row by a number or function? Just restating question
Asked by lupus - Wed Jul 23 16:03:21 2008 - - 3 Answers - 0 Comments
A. Try this formula in B2 =INDIRECT("A" & 2*2) if other cells are involved say, B3 = 2 , B4 = 2, =INDIRECT("A" & B3*B4) Then the formula will get you the value from A4 from the above formulas Want to deal with the column as well? try this =INDIRECT(ADDRESS(2*2, 1)) OR =INDIRECT(ADDRESS( B3*B4, 1)) Hope this helps.
Answered by AQuestionMark - Wed Jul 23 22:33:17 2008
How to reference a cell within a formula in Excel?
Q. Okay... what I have is a count function that counts up all the rows that have data and i have a sumproduct function that I was to =sumproduct(a2:a(b1))... where B1 is the count function so say B1=9, I want to have A2:A9 Please help me, this is driving me crazy!
Asked by Alex - Tue Jul 22 11:51:55 2008 - - 3 Answers - 0 Comments
A. The easiest way is to use indirect function, When B1= 9, the the following will return A2:A9 INDIRECT("A2:A" & B1)
Answered by AQuestionMark - Wed Jul 23 00:55:18 2008
Q. Okay... what I have is a count function that counts up all the rows that have data and i have a sumproduct function that I was to =sumproduct(a2:a(b1))... where B1 is the count function so say B1=9, I want to have A2:A9 Please help me, this is driving me crazy!
Asked by Alex - Tue Jul 22 11:51:55 2008 - - 3 Answers - 0 Comments
A. The easiest way is to use indirect function, When B1= 9, the the following will return A2:A9 INDIRECT("A2:A" & B1)
Answered by AQuestionMark - Wed Jul 23 00:55:18 2008
What does "unlocked" mean when used in reference to a cell phone being sold?
Q. I want to buy a cell phone on ebay and i noticed a lot of them say "unlocked." I have no idea what that means.
Asked by ali j. - Sun Jun 1 12:05:17 2008 - - 1 Answers - 0 Comments
A. Unlocked means it will work on any GSM network. If you buy a T-Mobile phone for example, it only works with other T-Mobile SIM cards. However, if the phone is unlocked, any network with SIM cards can use the phone, not just T-Mobile.
Answered by Spaceboy88 - Sun Jun 1 12:10:02 2008
Q. I want to buy a cell phone on ebay and i noticed a lot of them say "unlocked." I have no idea what that means.
Asked by ali j. - Sun Jun 1 12:05:17 2008 - - 1 Answers - 0 Comments
A. Unlocked means it will work on any GSM network. If you buy a T-Mobile phone for example, it only works with other T-Mobile SIM cards. However, if the phone is unlocked, any network with SIM cards can use the phone, not just T-Mobile.
Answered by Spaceboy88 - Sun Jun 1 12:10:02 2008
What do the letters SIM stand for in reference to a cell phone sim card?
Q. Why do some carriers use sim cards and others don't? Cingular,T.Mobile and Nextel do,verizon doesn't. What exactly do they do?
Asked by angie devine - Sat Nov 25 20:24:16 2006 - - 3 Answers - 0 Comments
A. A Subscriber Identity Module is a smart card roughly the size of a postage stamp that securely stores the key identifying a mobile phone service subscriber, as well as subscription information, saved telephone numbers, preferences, text messages and other information. The equivalent of a SIM in UMTS is a Universal Subscriber Identity Module (USIM). Sim cards are used by all GSM providers (Tmobile, Cingular, many others worldwide). If I take out my SIM card and put it into any other unlocked GSM phone that phone becomes my number instantly...no need to activate or transfer contacts etc. MikeC
Answered by MikeC - Sat Nov 25 20:28:06 2006
Q. Why do some carriers use sim cards and others don't? Cingular,T.Mobile and Nextel do,verizon doesn't. What exactly do they do?
Asked by angie devine - Sat Nov 25 20:24:16 2006 - - 3 Answers - 0 Comments
A. A Subscriber Identity Module is a smart card roughly the size of a postage stamp that securely stores the key identifying a mobile phone service subscriber, as well as subscription information, saved telephone numbers, preferences, text messages and other information. The equivalent of a SIM in UMTS is a Universal Subscriber Identity Module (USIM). Sim cards are used by all GSM providers (Tmobile, Cingular, many others worldwide). If I take out my SIM card and put it into any other unlocked GSM phone that phone becomes my number instantly...no need to activate or transfer contacts etc. MikeC
Answered by MikeC - Sat Nov 25 20:28:06 2006
How to cell reference in MS Excel?
Q. I'm trying to paste the results of a cell (that is, not the formula, but the result of the formula) to another cell in another worksheet. But just using copy and paste will copy the formula, not the result of it. How do I copy and paste just the results? Hold on, I worded this wrong: I need to transfer the internal formula, but only display the results. Does that make sense? Typing it in manually might look like this: "=worksheet1!(data here)"
Asked by Jake O - Mon Sep 1 23:36:23 2008 - - 2 Answers - 0 Comments
A. After Copy, click Paste Special, Value. You're welcome. -MM Edited: To make the formula absolute (that is not change when you copy it), first copy it, then hit F2 to edit, then hit F4 on each cell reference. You will see a '$" precede the cell. Hope that's what you want. Edited: No, you can't show =worksheet(data)
Answered by Wonder - Mon Sep 1 23:40:09 2008
Q. I'm trying to paste the results of a cell (that is, not the formula, but the result of the formula) to another cell in another worksheet. But just using copy and paste will copy the formula, not the result of it. How do I copy and paste just the results? Hold on, I worded this wrong: I need to transfer the internal formula, but only display the results. Does that make sense? Typing it in manually might look like this: "=worksheet1!(data here)"
Asked by Jake O - Mon Sep 1 23:36:23 2008 - - 2 Answers - 0 Comments
A. After Copy, click Paste Special, Value. You're welcome. -MM Edited: To make the formula absolute (that is not change when you copy it), first copy it, then hit F2 to edit, then hit F4 on each cell reference. You will see a '$" precede the cell. Hope that's what you want. Edited: No, you can't show =worksheet(data)
Answered by Wonder - Mon Sep 1 23:40:09 2008
From Yahoo Answer Search: 'Cell reference'
Sat Nov 21 01:20:02 2009 [ refresh local cache ]
[Hide]▼
news.google.com
ScienceBlogs
You now reject the model out of hand making no reference to the content of the book which includes 57 plates accurately predictive of causative models for a ...
imagereferencedatabase.com
75px x 100px | 1.90kB
[source page]
Cingular Motorola RAZR Cell Phone 8
[Hide]▲
