Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Naming Multiple pages for a formula chrisnelsonusa1 Excel Discussion (Misc queries) 1 July 4th 06 03:28 PM
i edit a formula (excel) then it displays formula not answer caiman Excel Discussion (Misc queries) 2 September 9th 05 02:09 AM
naming formula R.VENKATARAMAN Excel Worksheet Functions 5 January 1st 05 03:24 PM
I need to get this answer 8 - 1.2 = 6.2 from a formula T Excel Worksheet Functions 11 December 22nd 04 02:17 PM
If and (and) formula to allow a zero answer inthestands Excel Worksheet Functions 8 November 3rd 04 10:36 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"