I have an Excel spreadsheet cell which looks as follows:
A | B | C | D | E 1 TASK | WORK (days) | RESOURCES | PLUMBER (days) | ELECTRICIAN (days) 2 Fit bathroom | 3 | Plumber, Electrician | 1.5 | 1.5
Cells A2, B2 and C2 are entered manually.
The formula in cell D2 takes the total number of "Work" days (cell B2) and divides them by the number of resources specified in cell C2 (each resource is separated by a comma):
The formula for cell E2 is similar:
I'd like to modify my forumla to be able to deal with the following kind of entry in the C2 cell:
Plumber, Electrician [200%]
In this case, cell D2 should be set to 1 and cell E2 should be set to 2.
I hope this makes sense and would appreciate any help on how to achieve this.