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
George Gee - 13 Jan 2007 22:59 GMT
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
>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
[quoted text clipped - 5 lines]
> THANKS IN ADVANCE,
> THERESA
Bob Phillips - 15 Jan 2007 18:53 GMT
Just copy the formula down to the subsequent rows?

Signature
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
>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
[quoted text clipped - 5 lines]
> THANKS IN ADVANCE,
> THERESA