| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
EXECUTING A FORMULA
I HAVE A PROJECT WHERE I NEED TO CALCULATE TO FIND OUT IF AN EMPLOYEE IS
ELIGIBLE FOR A 401K ACCORDING TO THE YEARS WORKED AT THE COMPANY. I HAVE PUT IN THE FORMULA, HIGHLIGHTED THE COLUMNS, BUT WHEN I PRESS ENTER FOR THE CALCULATIONS TO APPEAR, I ALWAYS GET THIS ANSWER ONLY IN THE FIRST CELL $VALUE. SOMEONE PLEASE EXPLAIN TO ME WHAT I'M DOING WRONG... THANKS IN ADVANCE, THERESA |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
EXECUTING A FORMULA
In which cell have you put your formula?
What is your formula? You appear to have just highlighted the columns and not copied the formula across. Please do not post in all CAPITALS, it is considered rude. George Gee "THERESA" wrote in message ... I HAVE A PROJECT WHERE I NEED TO CALCULATE TO FIND OUT IF AN EMPLOYEE IS ELIGIBLE FOR A 401K ACCORDING TO THE YEARS WORKED AT THE COMPANY. I HAVE PUT IN THE FORMULA, HIGHLIGHTED THE COLUMNS, BUT WHEN I PRESS ENTER FOR THE CALCULATIONS TO APPEAR, I ALWAYS GET THIS ANSWER ONLY IN THE FIRST CELL $VALUE. SOMEONE PLEASE EXPLAIN TO ME WHAT I'M DOING WRONG... THANKS IN ADVANCE, THERESA |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
EXECUTING A FORMULA
Just copy the formula down to the subsequent rows?
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "THERESA" wrote in message ... I HAVE A PROJECT WHERE I NEED TO CALCULATE TO FIND OUT IF AN EMPLOYEE IS ELIGIBLE FOR A 401K ACCORDING TO THE YEARS WORKED AT THE COMPANY. I HAVE PUT IN THE FORMULA, HIGHLIGHTED THE COLUMNS, BUT WHEN I PRESS ENTER FOR THE CALCULATIONS TO APPEAR, I ALWAYS GET THIS ANSWER ONLY IN THE FIRST CELL $VALUE. SOMEONE PLEASE EXPLAIN TO ME WHAT I'M DOING WRONG... THANKS IN ADVANCE, THERESA |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
EXECUTING A FORMULA
DO YOU MEAN BESIDES USING CAPS LOCK???
"Bob Phillips" wrote: Just copy the formula down to the subsequent rows? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "THERESA" wrote in message ... I HAVE A PROJECT WHERE I NEED TO CALCULATE TO FIND OUT IF AN EMPLOYEE IS ELIGIBLE FOR A 401K ACCORDING TO THE YEARS WORKED AT THE COMPANY. I HAVE PUT IN THE FORMULA, HIGHLIGHTED THE COLUMNS, BUT WHEN I PRESS ENTER FOR THE CALCULATIONS TO APPEAR, I ALWAYS GET THIS ANSWER ONLY IN THE FIRST CELL $VALUE. SOMEONE PLEASE EXPLAIN TO ME WHAT I'M DOING WRONG... THANKS IN ADVANCE, THERESA |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
EXECUTING A FORMULA
Why are YOU shouting at me?
"Rookie 1st class" <Rookie1stClass@SpamThis wrote in message ... DO YOU MEAN BESIDES USING CAPS LOCK??? "Bob Phillips" wrote: Just copy the formula down to the subsequent rows? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "THERESA" wrote in message ... I HAVE A PROJECT WHERE I NEED TO CALCULATE TO FIND OUT IF AN EMPLOYEE IS ELIGIBLE FOR A 401K ACCORDING TO THE YEARS WORKED AT THE COMPANY. I HAVE PUT IN THE FORMULA, HIGHLIGHTED THE COLUMNS, BUT WHEN I PRESS ENTER FOR THE CALCULATIONS TO APPEAR, I ALWAYS GET THIS ANSWER ONLY IN THE FIRST CELL $VALUE. SOMEONE PLEASE EXPLAIN TO ME WHAT I'M DOING WRONG... THANKS IN ADVANCE, THERESA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Executing a formula based on criteria being met | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
