Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Change INSERT FUNCTION icon left of formula bar to = sign? | Setting up and Configuration of Excel | |||
How do I get an automatic equal sign to begin the formula bar? | New Users to Excel | |||
FORMULA TO ADD POSITIVE AND NEGATIVE NUMBERS, REGARDLESS OF SIGN | Excel Discussion (Misc queries) | |||
Formula to move cursor when 2 cells equal | Excel Discussion (Misc queries) |