Return to the Web Authoring Forum | Post a Follow-Up

o
Excel question

clip this post email this post what is this?
see most clipped and recent clippings
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

clip this post email this post what is this?
see most clipped and recent clippings

=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

clip this post email this post what is this?
see most clipped and recent clippings

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.

o Post a Follow-Up

Please Note: Only registered members are able to post messages to this forum.

    If you are a member, please log in.

    If you aren't yet a member, join now!

Return to the Web Authoring Forum

Instructions

  • You must be a registered member and logged in to post messages on our forums.
  • Posting is a two-step process. Once you have composed your message, you will be taken to the preview page. You will then have a chance to review the contents and make changes.
  • After posting your message, you may need to refresh the forum page in order to see it.
  • It is illegal to post copyrighted material without the owner's consent.
  • HTML codes are allowed in the message field only.
  • No advertising is allowed in any of the forums.
  • If you would like to practice posting or uploading photos, please visit our Test forum.
  • If you need assistance, please Contact Us and we will be happy to help.



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