Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP WITH FORMULAS
WHENEVER I TRY TO ADD INFORMATION TO AN EXISTING FORMULA OR CREATE A
NEW FORMULA THE FORMULA APPEARS INSTEAD OF THE REULT EXISTING FORMULAS ALL SHOW THE RESULT HOWEVER, ALSO SOME OF THE FORMULAS ARE NOT COUNTING THE CORRECT VALUE OR SUMMING UP TO THE CORRECT FIGURE ANY HELP WOULD BE APPRECIATED |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP WITH FORMULAS
Are you inserting a space before the = sign when changing or making new
formulas or are the cells preformatted to 'text'? Try formatting the cells as general 1st. as an aside..(All caps is like shouting and is not the best keyboard etiquette.) "TURTILLD" wrote: WHENEVER I TRY TO ADD INFORMATION TO AN EXISTING FORMULA OR CREATE A NEW FORMULA THE FORMULA APPEARS INSTEAD OF THE REULT EXISTING FORMULAS ALL SHOW THE RESULT HOWEVER, ALSO SOME OF THE FORMULAS ARE NOT COUNTING THE CORRECT VALUE OR SUMMING UP TO THE CORRECT FIGURE ANY HELP WOULD BE APPRECIATED |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |