naming an answer in a formula

  • Thread starter Thread starter T-bart
  • Start date Start date
T

T-bart

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Formula Help 1
Calculating an interpolation 1
Function Error 4
Math Formula 6
how do i calculate 2' x 4' x 4" 5
formula for spreadsheet 2
putting a name in a formula 2
Formulas don't work in certain cells 2

Back
Top