JOIN NOW LOG IN
iVillage GardenWeb iVillage GardenWeb THE INTERNET'S GARDEN & HOME COMMUNITY ADVERTISEMENT
Blogs Forums Photo Galleries Ask The Experts Tools & Directories        
Return to the Web Authoring Forum | Post a Follow-Up

 o
Excel question

Posted by
Richard Duke
(rduke25@home.com) on
Sat, Nov 17, 01 at 9:42

I am using excel XP.

How do you add a value with in a singel cell. When I try say working with cell L12 and I want to add cell L11 plus add a new value to L12,how is this done. When I try Sum(L11+L12) and hit the check mark I get a error. I am trying to add weekly values to a running monthly value in a single cell. Thanks for any help. Richard


Follow-Up Postings:

 o
RE: Excel question

=sum(L11;L12) for the range of L11 to L12
or
=sum(L11;L39) for the range of L11 to/and L39
(the '='-symbol helps excel to understand you want to do a calculation)

Or to simply add two cells:
=L11+L12

When you type the '='-symbol, simply select the cells you wanna add and hit the enter-button.

This works for excel2000, but i dont think it will differ in XP.

Good luck,

Niels.

P.S. Actually this is a question for the computer-help-forum and not the HTML-forum ;-)


 o
RE: Excel question

As to including your "new Value" Did you try?
=sum(L11:L12)*L6 (To multiply) or
=sum(L11:L12)/3 (To divide)
=sum(L11*4)+L12 Depending on where your new value plugs in.


 
 

 

 


Click here to learn more about in-text links on this page.



iVillage GardenWeb: The Internet's Garden & Home Community  
  iVillage Home & Garden Network