Question Locked

Excel: text and value in cell to be then used in a formula?

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

2 replies

by thumbsup2

When you add text to the contents of cell A1, you turn it into a cell that you can't apply math to. Try inserting a column between A1 and A2 and putting your kWh text into it istead of into A1. Then, do the math.

As far as adding a comma, just format the cell as a number using the appropriate mask.

---

This discussion is closed to new replies.