ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   naming an answer in a formula (https://www.excelbanter.com/excel-discussion-misc-queries/173544-naming-answer-formula.html)

T-bart

naming an answer in a formula
 
This is probably a piece of cake so excuse my ignorance. I cannot seem to
figure out how to label an answer in a formula for example: I want to add
numbers that are square feet and label the answer "square feet" eg.
1000+2000=3000 square feet. How do I write the formula to include sq ft with
the answer. Thanks

Native

naming an answer in a formula
 
Couple ways....

1) have the 1000 and 2000 in other cells A1 and A2 and write the
equation as =A1+A2&" square feet"
2) on the cell where the answer is, go to Format Cells, go to Custom
along the side selections, then on the General modify the Type: field
to 'General "square feet"' (no single quote around the whole phrase,
just the quotes around square feet



All times are GMT +1. The time now is 01:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com