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