Here have some information in cell A1.
Then cell B1 has a formula (called "Formula1") to modify A1, resulting in B1 value.
Then cell C1 has a formula (called "Formula2") to modify B1 whose value was created after applying its formula to A1, resulting in C1 value.
Is there a way that I can write a formula which asks him in a single cell to do first formula 1 then formula 2 without needing to write 2 different formulas in different cells?
I tried writing in the formula box like this but it is comparing one to another instead of doing one then the other with the result of the first one:
Also tried =Formula1&Formula2 and =Formula1+Formula2, but they do other things...
How could I write formulas in a single cell saying:
=Formula1 THEN Formula2 THEN Formula3, etc. (each higher formula being done to the result of the former one)
Formula1 for column B: =LEFT(A1,FIND("$",A1& "$")-1)
Formula2 for column C: =IF(SUMPRODUCT(LEN(B1)-LEN(SUBSTITUTE(B1,"$","")))=1,LEFT(B1,FIND("$",B1)-1),IF(SUMPRODUCT(LEN(B1)-LEN(SUBSTITUTE(B1,"%","")))=1,MID(B1,FIND("%",B1)+1,LEN(B1)-FIND("%",B1)),IF(SUMPRODUCT(LEN(B1)-LEN(SUBSTITUTE(B1,".","")))>=1,B1,"")))
I am having to write column A, Then do formula1 for getting column B, Then again do formula2 on top of column B value after its formula 1 result, for just then to get column C. This is making the excel chart display information that I dont want it to appear nor calculate by parts, but show only final result calculated at once.
I would like to have only columns A and B in which A is the input, and B has all the formulas calculated at once. How do I do one single formula with those 2 formulas to be done first formula1 and then formula2 applied to formula1 result directly?