I've got "[Years Service]" and "[Pay Grade]" in the same workbook with
sheet
names and cell addresses.

Not from the formula you are showing!



--
Regards
Dave Hawley
www.ozgrid.com
"Stana1027" wrote in message
...
I've got "[Years Service]" and "[Pay Grade]" in the same workbook with
sheet
names and cell addresses.
The AND calculation is whats causing the problems...and my book doesn't
show
the AND function used with the IF function.

"ozgrid.com" wrote:

What is "[Years Service]" and "[Pay Grade]"??????? If another Workbook,
you
need sheet names and cell addresses.



--
Regards
Dave Hawley
www.ozgrid.com



"Stana1027" wrote in message
...
Trying to calculate bonus's for employees working 1 year, and based on
their
pay grade. Yet I'm getting #value, and Excel says I'm using the data
type?
help please!

=IF(AND([Years Service]=1, "NE"), IF([Pay Grade]=1,$Z$6,IF([Pay
Grade]=2,
$Z$7, IF([Pay Grade]=3, $Z$8, "Invalid pay grade"))))