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

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

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

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

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