Is there a way in Excel to type a person's name in a cell and have it calculate their gross pay?
I'm doing a project for a computer class and I have a group of hypothetical employees.
There are three columns: employee, hours worked, and wage. Is there a way to format the employee's name so that when I type it and hit enter, it calculates their hours worked for that day multiplied by their hourly rate?
Any help would be greatly appreciated!! Thanks!
|