If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula
Hi
Perhaps I have not been very clear. Let me illustrate with a more concrete eg. In row 1, I have 1, 2, 5, 100, and other random numbers. In row 2, I want 1*3, 2*3, 100*3 and so on. But the difficulty is that I DON'T want only the final value in row 2. I want to be able to see =1*3, =2*3, .... in the formula box when I click on each cell. If I use the below method, I will only be able to obtain the final value. Is there any way I will be able to obtain what I want? Thank you. "מיכאל (מיקי) אבידן" wrote: If I understood you correctly - try this. * In cell D28 [or any empty cell] type 3 and hit CTRL+C for 'Copy'. * Select the range of cells of data in row 1. * Go to 'Edit' 'PasteSpecial' click on 'Multiply' 'OK' * Delete cell A10 Micky "PL" wrote: Using Excel 2003. I want all the data in a row to take a specific formula, say = X * 3. But the value of X varies for each of the cell. How do I do so without having to type in the same formula for each cell? Furthermore I want the value of X for each cell to be seen. Thus I don't want to enter all X in row 1 , and in row 2 enter =A1*3. Then copy & paste the formula onto the entire row. Because by doing this, people can't tell what is A1, B1,.... Thank you. |
#2
|
|||
|
|||
Formula
I am not sure I understood your query. The formula bar should display A1*3,
A2*3 and so on...in cell A2, B2 ... Are you trying to display the text as below. Enter the formula in cell A2 and copy to the right as required. =A1&"*3" -- Jacob "PL" wrote: Hi Perhaps I have not been very clear. Let me illustrate with a more concrete eg. In row 1, I have 1, 2, 5, 100, and other random numbers. In row 2, I want 1*3, 2*3, 100*3 and so on. But the difficulty is that I DON'T want only the final value in row 2. I want to be able to see =1*3, =2*3, .... in the formula box when I click on each cell. If I use the below method, I will only be able to obtain the final value. Is there any way I will be able to obtain what I want? Thank you. "מיכאל (מיקי) אבידן" wrote: If I understood you correctly - try this. * In cell D28 [or any empty cell] type 3 and hit CTRL+C for 'Copy'. * Select the range of cells of data in row 1. * Go to 'Edit' 'PasteSpecial' click on 'Multiply' 'OK' * Delete cell A10 Micky "PL" wrote: Using Excel 2003. I want all the data in a row to take a specific formula, say = X * 3. But the value of X varies for each of the cell. How do I do so without having to type in the same formula for each cell? Furthermore I want the value of X for each cell to be seen. Thus I don't want to enter all X in row 1 , and in row 2 enter =A1*3. Then copy & paste the formula onto the entire row. Because by doing this, people can't tell what is A1, B1,.... Thank you. |
#3
|
|||
|
|||
Formula
Hi
I want the formula bar to display = 1*3, =2*3, = 5*3, =100*3 ..... for each cell. NOT = A1*3, A2*3 and so on...in cell A2, B2 ... But I don't think there is any way to do this, is there? thanks "Jacob Skaria" wrote: I am not sure I understood your query. The formula bar should display A1*3, A2*3 and so on...in cell A2, B2 ... Are you trying to display the text as below. Enter the formula in cell A2 and copy to the right as required. =A1&"*3" -- Jacob "PL" wrote: Hi Perhaps I have not been very clear. Let me illustrate with a more concrete eg. In row 1, I have 1, 2, 5, 100, and other random numbers. In row 2, I want 1*3, 2*3, 100*3 and so on. But the difficulty is that I DON'T want only the final value in row 2. I want to be able to see =1*3, =2*3, .... in the formula box when I click on each cell. If I use the below method, I will only be able to obtain the final value. Is there any way I will be able to obtain what I want? Thank you. "מיכאל (מיקי) אבידן" wrote: If I understood you correctly - try this. * In cell D28 [or any empty cell] type 3 and hit CTRL+C for 'Copy'. * Select the range of cells of data in row 1. * Go to 'Edit' 'PasteSpecial' click on 'Multiply' 'OK' * Delete cell A10 Micky "PL" wrote: Using Excel 2003. I want all the data in a row to take a specific formula, say = X * 3. But the value of X varies for each of the cell. How do I do so without having to type in the same formula for each cell? Furthermore I want the value of X for each cell to be seen. Thus I don't want to enter all X in row 1 , and in row 2 enter =A1*3. Then copy & paste the formula onto the entire row. Because by doing this, people can't tell what is A1, B1,.... Thank you. |
#4
|
|||
|
|||
Formula
You can make the cell look like that as mentioned in my previous post but not
the formula bar..where it shows the cell reference.. -- Jacob "PL" wrote: Hi I want the formula bar to display = 1*3, =2*3, = 5*3, =100*3 ..... for each cell. NOT = A1*3, A2*3 and so on...in cell A2, B2 ... But I don't think there is any way to do this, is there? thanks "Jacob Skaria" wrote: I am not sure I understood your query. The formula bar should display A1*3, A2*3 and so on...in cell A2, B2 ... Are you trying to display the text as below. Enter the formula in cell A2 and copy to the right as required. =A1&"*3" -- Jacob "PL" wrote: Hi Perhaps I have not been very clear. Let me illustrate with a more concrete eg. In row 1, I have 1, 2, 5, 100, and other random numbers. In row 2, I want 1*3, 2*3, 100*3 and so on. But the difficulty is that I DON'T want only the final value in row 2. I want to be able to see =1*3, =2*3, .... in the formula box when I click on each cell. If I use the below method, I will only be able to obtain the final value. Is there any way I will be able to obtain what I want? Thank you. "מיכאל (מיקי) אבידן" wrote: If I understood you correctly - try this. * In cell D28 [or any empty cell] type 3 and hit CTRL+C for 'Copy'. * Select the range of cells of data in row 1. * Go to 'Edit' 'PasteSpecial' click on 'Multiply' 'OK' * Delete cell A10 Micky "PL" wrote: Using Excel 2003. I want all the data in a row to take a specific formula, say = X * 3. But the value of X varies for each of the cell. How do I do so without having to type in the same formula for each cell? Furthermore I want the value of X for each cell to be seen. Thus I don't want to enter all X in row 1 , and in row 2 enter =A1*3. Then copy & paste the formula onto the entire row. Because by doing this, people can't tell what is A1, B1,.... Thank you. |
#5
|
|||
|
|||
Formula
="="&A1&"*3" , and copy across,
will display your "formula" as text. It won't, of course, do the calculation, so if you want to do that you'd need to do so in a separate cell. -- David Biddulph "PL" wrote in message ... Hi I want the formula bar to display = 1*3, =2*3, = 5*3, =100*3 ..... for each cell. NOT = A1*3, A2*3 and so on...in cell A2, B2 ... But I don't think there is any way to do this, is there? thanks "Jacob Skaria" wrote: I am not sure I understood your query. The formula bar should display A1*3, A2*3 and so on...in cell A2, B2 ... Are you trying to display the text as below. Enter the formula in cell A2 and copy to the right as required. =A1&"*3" -- Jacob "PL" wrote: Hi Perhaps I have not been very clear. Let me illustrate with a more concrete eg. In row 1, I have 1, 2, 5, 100, and other random numbers. In row 2, I want 1*3, 2*3, 100*3 and so on. But the difficulty is that I DON'T want only the final value in row 2. I want to be able to see =1*3, =2*3, .... in the formula box when I click on each cell. If I use the below method, I will only be able to obtain the final value. Is there any way I will be able to obtain what I want? Thank you. "????? (????) ?????" wrote: If I understood you correctly - try this. * In cell D28 [or any empty cell] type 3 and hit CTRL+C for 'Copy'. * Select the range of cells of data in row 1. * Go to 'Edit' 'PasteSpecial' click on 'Multiply' 'OK' * Delete cell A10 Micky "PL" wrote: Using Excel 2003. I want all the data in a row to take a specific formula, say = X * 3. But the value of X varies for each of the cell. How do I do so without having to type in the same formula for each cell? Furthermore I want the value of X for each cell to be seen. Thus I don't want to enter all X in row 1 , and in row 2 enter =A1*3. Then copy & paste the formula onto the entire row. Because by doing this, people can't tell what is A1, B1,.... Thank you. |
#6
|
|||
|
|||
Formula
"PL" wrote:
I want the formula bar to display = 1*3, =2*3, = 5*3, =100*3 ..... for each cell. NOT = A1*3, A2*3 and so on...in cell A2, B2 ... But I don't think there is any way to do this, is there? You can do this (at least, in Excel 2003); but it might not be as automatic as you would like. Suppose A1=1, A2=2, A3=3, A4=4, and B1 has the formula =(A1+A2)*A3/A4. Select B1, double-click each cell reference (A1, A2, etc) in the Formula Bar, and press F9. The cell references are replaced by their values. If you do that for all cell references, you will see =(1+2)*3/4. Caveat: Be sure to press Esc when you are done. If you press Enter, the formula in B1 will be changed. You can press ctrl+Z to undo the change, if you realize it soon enough. PS: The F9 feature is not limited to replacing just cell references with their values. It can be used to evaluate any sub-expression in the Formula Bar. |
#7
|
|||
|
|||
Formula
Clarification....
I wrote: Select B1, double-click each cell reference (A1, A2, etc) in the Formula Bar, and press F9. That might be unclear. What I mean is: for each cell reference, double-click the cell reference and press F9. You cannot double-click all of the cell references, then press F9 once. That is not what I meant to say. ----- original message ----- "Joe User" wrote: "PL" wrote: I want the formula bar to display = 1*3, =2*3, = 5*3, =100*3 ..... for each cell. NOT = A1*3, A2*3 and so on...in cell A2, B2 ... But I don't think there is any way to do this, is there? You can do this (at least, in Excel 2003); but it might not be as automatic as you would like. Suppose A1=1, A2=2, A3=3, A4=4, and B1 has the formula =(A1+A2)*A3/A4. Select B1, double-click each cell reference (A1, A2, etc) in the Formula Bar, and press F9. The cell references are replaced by their values. If you do that for all cell references, you will see =(1+2)*3/4. Caveat: Be sure to press Esc when you are done. If you press Enter, the formula in B1 will be changed. You can press ctrl+Z to undo the change, if you realize it soon enough. PS: The F9 feature is not limited to replacing just cell references with their values. It can be used to evaluate any sub-expression in the Formula Bar. |
Thread Tools | |
Display Modes | |
|
|