Need a formula to act as a value

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.
 
C

Claus Busch

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

VLOOKUP 2
Excel VBA 1
Show Hrs:Min 5
Index with partial text 1
VLookup Within a Range 2
Conditional formatting based on formula cell 6
Excel formula, sum the value cell and if empty cell left blank 0
Formula not working - vlookup 1

Top