Ask Your Question
0

CALC - Formula to Text

asked 2015-11-17 15:23:01 +0200

stockdam gravatar image

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.

edit retag flag offensive close merge delete

Comments

Hi,

For example if the result of a formula in C3 is A4 you can do:

CONCATENATE("=COUNTIF(";C3;":A1,'S')")

Maybe this could help... But I can't seem to make libreoffice process the result as a formula...:(

Unkuiri gravatar imageUnkuiri ( 2015-12-23 00:13:00 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2016-07-14 20:24:12 +0200

erAck gravatar image

Take a look at the INDIRECT function, for your example it would be something like =COUNTIF(INDIRECT("A1:" & somecalculationthatreturnsa4asstring),"S")

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-11-17 15:23:01 +0200

Seen: 636 times

Last updated: Jul 14 '16