Need a formula to act as a value

  • Thread starter Thread starter rene.glass
  • Start date Start date
R

rene.glass

I have a formula that references another sheet. It displays as a formula, I need to multiply the value displayed with another cell value.
 
Hi René,

Am Wed, 7 Jan 2015 08:48:13 -0800 (PST) schrieb (e-mail address removed):
I have a formula that references another sheet. It displays as a formula, I need to multiply the value displayed with another cell value.
Click to expand...

if it is displayed as a formula your cell is text formatted.
Do you want to multiply the value in the same cell? Then change the
formula to:
=oldFormula * cell reference
e.g. =Sheet2!B1*D1

If you would do it in another cell then
=cell reference formula * cell reference value


Regards
Claus B.
 
Back
Top