Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel question


  • Please log in to reply

#1
diggeryo

diggeryo

    Member

  • Member
  • PipPipPip
  • 343 posts
I am currently using Microsoft Excel 2007 (on Windows XP SP2).

I have an Excel file with which I track my finances. There are times when I have a certain figure in a cell and I need to add another figure to it. I end up adding the figure in a hand held caluclator and then overwriting the cell of the original figure with the new figure.

Is there any way I can set up cells in Excel to behave like a calculator? For example, if I have the figure "$11.50" in a cell, and I want to add $1.50 to it, I can simply click on the cell and type "+1.50" and it would change the figure to "$13.00"

Thanks for any help,
mike.
  • 0

Advertisements


#2
piper

piper

    Retired Staff

  • Retired Staff
  • 2,459 posts
Hi, diggeryo.

The answer is "kind of" (for Office 2000, 2002, & 2003). See the attachments. If you put your cursor in the cell, then click in the formula bar just to the left of the number, you can then key in the numbers you need to add. I would think Office 2007 would be the same. If it isn't, please post back.

[attachment=13377:diggeryo_excel.JPG]

[attachment=13378:diggeryo_excel_2.JPG]

Edited by LindaGail, 12 March 2007 - 05:48 AM.

  • 0

#3
diggeryo

diggeryo

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 343 posts
Thanks, LG. I will give that a try.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP