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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show Hrs:Min 5
Excel VBA 1
Help needed 0
VLOOKUP 2
Advanced Vlookup Formula 2
Take an average of data where lookup in array is needed 3
Cell shows the last typed text, no matter where it is typed 0
Excel formula, sum the value cell and if empty cell left blank 0

Back
Top