i've searched microsoft.public.excel with keywords "formula
substitute values", but haven't found the answer.
Please help if you know how to do it.
Thanks in advance!

You could do it like this:

=A1&" + "&B1&" * "&C1

Hope this helps.

Pete

On Oct 12, 10:31 am, vaso82 wrote:
i've searched microsoft.public.excel with keywords "formula
substitute values", but haven't found the answer.
Please help if you know how to do it.
Thanks in advance!

Thanx for quick reply but i need to have c=7 and a convinent way to
type the formula

On 12 , 13:47, Pete_UK wrote:
You could do it like this:

=A1&" + "&B1&" * "&C1

Hope this helps.

Pete

On Oct 12, 10:31 am, vaso82 wrote:

i've searched microsoft.public.excel with keywords "formula
substitute values", but haven't found the answer.
Please help if you know how to do it.
Thanks in advance!

I don't know what you mean.

Pete

On Oct 12, 10:58 am, vaso82 wrote:
Thanx for quick reply but i need to have c=7 and a convinent way to
type the formula

On 12 , 13:47, Pete_UK wrote:



You could do it like this:

=A1&" + "&B1&" * "&C1

Hope this helps.

Pete

On Oct 12, 10:31 am, vaso82 wrote:

i've searched microsoft.public.excel with keywords "formula
substitute values", but haven't found the answer.
Please help if you know how to do it.
Thanks in advance!- Hide quoted text -

- Show quoted text -

Sorry i must be dumb today, but i need both: the value of D should be
7, and the cell should show "1+2*3"
Can it be done?

On 12 , 15:53, Pete_UK wrote:
I think what you really want is:

=A1+B1*C1

in D1 - this will give you the result of 7 in D1, if you have the
values stated earlier.

Hope this helps.

Pete

On Oct 12, 12:48 pm, vaso82 wrote:

i mean i need to have d equal to the result of a+b*c, not the string
"1+2*3"
And it's rather unconvinient to type all this ampersands and quotes.

On 12 , 14:46, Pete_UK wrote:

I don't know what you mean.

Pete

On Oct 12, 10:58 am, vaso82 wrote:

Thanx for quick reply but i need to have c=7 and a convinent way to
type the formula

On 12 , 13:47, Pete_UK wrote:

You could do it like this:

=A1&" + "&B1&" * "&C1

Hope this helps.

Pete

On Oct 12, 10:31 am, vaso82 wrote:

i've searched microsoft.public.excel with keywords "formula
substitute values", but haven't found the answer.
Please help if you know how to do it.
Thanks in advance!- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

vaso,
The cell can have a formula and a value. In order for the cell's value to
be 7, it can have a formula of =A1+B1*C1 or =1+2*3, but not both! If you
want to put in the formula with the numbers for just for the one cell, you
could do it with worksheet_change event code, but you wouldn't want such
events occurring in multiple cells. Or, you could do it for multiple cells
with a standard macro, but it would not update automatically when cells A1,
B1, or C1 are changed. James

"vaso82" wrote in message
oups.com...
Sorry i must be dumb today, but i need both: the value of D should be
7, and the cell should show "1+2*3"
Can it be done?

On 12 , 15:53, Pete_UK wrote:
I think what you really want is:

=A1+B1*C1

in D1 - this will give you the result of 7 in D1, if you have the
values stated earlier.

Hope this helps.

Pete

On Oct 12, 12:48 pm, vaso82 wrote:

i mean i need to have d equal to the result of a+b*c, not the string
"1+2*3"
And it's rather unconvinient to type all this ampersands and quotes.

On 12 , 14:46, Pete_UK wrote:

I don't know what you mean.

Pete

On Oct 12, 10:58 am, vaso82 wrote:

Thanx for quick reply but i need to have c=7 and a convinent way to
type the formula

On 12 , 13:47, Pete_UK wrote:

You could do it like this:

=A1&" + "&B1&" * "&C1

Hope this helps.

Pete

On Oct 12, 10:31 am, vaso82 wrote:

i've searched microsoft.public.excel with keywords "formula
substitute values", but haven't found the answer.
Please help if you know how to do it.
Thanks in advance!- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Press Alt F11
Insert New Module
Paste this in the module


Function FormulaIs(myCell As Range)

FormulaIs = "'" & myCell.Formula

End Function

THis ASSUMES only one cell is used in the formula.

IN aqn adgacent cell to your formula, enter

=FormulaIS(A1)

Or other appropriate reference.

You'll get the formula in A1.
--
HTH,
Barb Reinhardt



"vaso82" wrote:

i've searched microsoft.public.excel with keywords "formula
substitute values", but haven't found the answer.
Please help if you know how to do it.
Thanks in advance!