lookinf for formula , single cell two numerical values , multiply in different columns

Hi,

Edit: cross-posted:

http://www.mrexcel.com/forum/excel-q...t-columns.html

It's possible, but it would be useful if you could upload an actual workbook with several examples and your desired results clearly outlined.

Regards

Thanks.

I don't understand why you can't put the values 4006.23 and 6542.73 from column L into separate columns, and then add them in another column. That way you can also reference them in other formulas.

Regards

Provide Excel File with Data and Required Output

Originally Posted by land_land

because for EUR currency i have only one column as a source

But you've manually typed =4006.23+6542.73 into each of those cells?

So why can't you put 4006.23 into e.g. K1 and 6542.73 into e.g. L1 and then put =K1+L1 into e.g. M1?

Regards

Then if you really want to do as you say you'll have to save your workbook as macro-enabled so that you can use the following set-up:

With the active cell in the sheet somewhere in row 2, go to Name Manager and define a new name:

Name: Value1
Refers to: =GET.CELL(6,'Purch 2014'!$L2)

Exit Name Manager.

The formula in P2 is then:

=MID(Value1,2,FIND("+",Value1)-2)*$N2

And that in Q2:

=MID(Value1,FIND("+",Value1),99)*$N2

I have to say that I think this is a seriously overly-complicated solution to your problem though, and one which is also prone to error.

If you're "not allowed" to save it as a macro-enabled workbook either, then I can't help you any further.

Regards

Originally Posted by land_land

Thank you XOR LX!

it worked your formula , yes i can save as macro enables.

Punnam solution was not practical because values can change every month, unable to use name manager for every registration in different values

thank you guys
God bless you
Roland,

You're welcome!