Automatically multiply 2 cells and get the result in the 1st cell

Hello!

I have 2 Excel sheets, each of them have 13 columns (Jan->Dec+name of the persons) and 21 rows (values for each person) with different data: in the 1st sheet the workload in percentage for each month for each person, and in the 2nd sheet a number corresponding to the availability of the person for each month and each person.

When I type the percentage of completion in the first sheet for each person, I would like the same cell of the workload in percetange to multiple with the number from 2nd sheet (availability corresponding to the same month and the same person) and show the result in the same cell in the 1st sheet.

 

Thanks in advance!

 

If not clear, i will try to be more explicit!

By: Denisa

Leave a Reply

Your email address will not be published. Required fields are marked *