Complicated multiply function

[ategkelidis]

Dear Friend,

Apologies for what I feel it is a pretty stupid question, however it seems impossible for me find my way out of this. Here is what I am trying to do:

I have to cells, cell 1 and cell 2. I would like to type any number into cell 1 and have this number multiplied by the number I have given in the cell 2.

Is this is even possible to do?

Thank you in advance for your reply and help.

Cheers,

Adam.

[shg]

In cell3: =cell1 * cell2

If you wanted the result to appear in cell1, it would require VBA.

[AliGW]

Welcome to the forum.

Not in just two cells with a formula, however it can be done in a third cell.

A1 = Chosen number

A2 = Chosen multiplier

A3:

=A1*A2

Is this suitable? If not, you may need VBA.

[ategkelidis]

Thank you so much for the rapid reply!

Yes this is exactly what I want... Unfortunately no chance to get it in this life... I will figure another way out.

Thank you very much again!

[AliGW]

What does that mean?

[ategkelidis]

What does that mean?

oops so sorry that was meant to be a reply to the chilean friend that replied before! Learning to script in VB would not be an option for the moment.

Thank you too so much as well both for the help and the wishes! It feels nice to be here and getting so much help that fast!

Best wishes from me as well,

Adam.

[AliGW]

Chilean friend?

Are we done here, or do you still need help?

Perhaps you misidentified the flag? It’s the Texan flag, the lone star state. Last time I checked, Texas was in the USA, not Chile.