How to calculate from display of cell with formula in it

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

Seems like there is a way to do it, but I have forgotten.
..
cell A1 contains a formula that returns a result from an
index and match, which is a price of a product. Say
$25.00. The formula bar shows the formula, but the cell
displays the result. ($25.00). I wish to multiply this
result by the quantity (Cell C3) but if I enter =A1*C3..I
get no result.
..
 
Hi

What do you mean by 'I get no result'? What does the cell display? Initial
thoughts are that maybe your calculation is set to manual - Tools / Options
/ Calculation
 
Amazing how I tend to overlook the simplest things.
I typed in the multiplication formula and it just stayed
there. (Format was Text...Duh!)..However if I change the
format to general or accounting I get the error "#Value"
..
I copied the results to another cell with Paste Special
(Values) which works, but I wonder if there is a way to
calculate directly from the original formula cell.
thanks
 
It sounds like one of your 'numbers' is text. Try:
=VALUE(A1*C3)
You could use a helper column alongside your data with
=ISNUMBER(A1) and another with
=ISNUMBER(C3)
to find out which is causing problems.
 
Back
Top