Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

CALC - Formula to Text

Hi, I want to use the calculated result of a cell formula as part of another formula.

So for example a cell calculates the reference of a cell containing a value (for example the calculation would display A4 as the result. I then want to use this value in another Formula, for example = COUNTIF(A4:A1,"S")

I don't want to manually copy and Paste Special but need a way to convert the formula in the first cell to a value and then use this as part of a second formula.