![]() |
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 |
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