Formula which references cell values.

[jbodell]

Hello,

I'm fumbling to put a formula together which takes:

A1 = 5 (will always be a numeric value)
B1 = .8 (will always be a decimal)

and produces

C1 = =5*.8

I'm not looking to simply calculate A1*B1- I need C1 to actually read as the calculation, but with C1's formula referencing the values in A1 and B1 (as with- "=5*.8" given the values above). If I need to do a special paste or perform multiple steps to achieve this that'd be fine.

Thank you for your help!

 

[nickshep85]

Try this in C1

="="&A1&"*"&B1

 

[jbodell]

Thanks nicksteph85.

I should have been a little clearer. I'd like C1 to calculate the formulate A1*B1, but for the formula to read as =5*.8 so that it can be manipulated independently to A1 and B1.

Does that make sense?

Thank you.

 

[jbodell]

I cracked it...it's =VALUE(A1)&"*"&VALUE(B1) then pasting that value and refreshing the cell.

Thank you for getting me started nicksteph85.