Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joes Auto Pat
 
Posts: n/a
Default Formula bar doesn't have an equal sign

I am an old die hard. Just updated from Office 97 to Office xp. Believe me
I'm no whiz.

The function bar in 97 had and x a checkmark and and equal sign. This
totaled all figures in the cell. Now I only have a fx and I have no idea how
to simply get it to total.

Also my cell formulas have changed. I get the correct answer, but do I make
a new formula the old way or a new way.

Thanks,

Pat
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kassie
 
Posts: n/a
Default Formula bar doesn't have an equal sign

Nowadays, you start your formula with an = sign. to sum, click on the SUM
icon, or type in =SUM(<your starting cell ref:<your ending ref), eg
=SUM(B1:B15)
You can also use the fx icon to use a wizard to assist you.

"Joes Auto Pat" wrote:

I am an old die hard. Just updated from Office 97 to Office xp. Believe me
I'm no whiz.

The function bar in 97 had and x a checkmark and and equal sign. This
totaled all figures in the cell. Now I only have a fx and I have no idea how
to simply get it to total.

Also my cell formulas have changed. I get the correct answer, but do I make
a new formula the old way or a new way.

Thanks,

Pat

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
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM
Change INSERT FUNCTION icon left of formula bar to = sign? Jamie Setting up and Configuration of Excel 1 January 19th 06 02:47 PM
How do I get an automatic equal sign to begin the formula bar? scarlette belle New Users to Excel 1 January 5th 06 11:07 PM
FORMULA TO ADD POSITIVE AND NEGATIVE NUMBERS, REGARDLESS OF SIGN JON Excel Discussion (Misc queries) 3 July 18th 05 06:35 PM
Formula to move cursor when 2 cells equal mikeburg Excel Discussion (Misc queries) 2 July 8th 05 12:22 AM


All times are GMT +1. The time now is 01:53 AM.

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

About Us

"It's about Microsoft Excel"