Hi!

I have to have a drop-down list, which will decide of a value to use for calculations (to print in a cell?). In that particular case, the choice has to be "Employees" or "Hours" (with an equivalence 1 employee = 40 hours). I want the choosing person to see the word "Employees" or "Hours", but not the associated numbers. I don't want to use cell space to plug in "Employees" next to "1" and "Hours" next to "40".

Is there a way to show the word "Hours" while calculations can be made with the value "40"?

Does this make sense?

Thanks!