Hi Guys,


I have a dropdown menu from which i choose pay codes like ISPD, PEM, and DEG.
I have defined these names with the appropriate values 77, 20 and 44 respectively.

when i try to multiply the paycode (ISPD) with the number of hours (3)
in the format below (so that the drop down list can be utilised)

=Product (F7,G7)

it returns 3 rather than 231

Please help!


Thanks

Ben