I’m trying to use a formula and text combined cell in another formula (as a reference), but am getting an error.
Example,
A1(referenced cell): =ROUND(Inputs!I56,2)&” kWh”
A2(reference cell): =180000*A1/3
and I get a #VALUE! error in A2… help?
Also, i’d like to include a cell format, such as a comma in the result. Is this possible?