Formula

[PL]

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.

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

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.

 

[Jacob Skaria]

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

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.

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

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.

 

[PL]

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

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

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.

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


:

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.

 

[Jacob Skaria]

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

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

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

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.

:

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


:

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.

 

[Joe User]

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.

 

[Joe User]

Clarification....

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 -----