Hi,
Reopening a project you guys have previously helped me with, everything you did works well but I am just looking for a slight amendment.
I have attached the project and removed sensitive data, sheet 2 & 3 are locked as these need no change.
Sheet 1 Tuesday onward is not needed so again cells are locked.
This example focuses on sheet 1 cells C3:T38 and V3:W38 and I think its the formulas in columns V&W that need amending.
V6:Y7 show the results I am looking for but I want this to be true when the data in D9:R10 is used and not the data currently used as in D6:R7.
Basically it already works exactly as I want except I want,
0.25 in D6 to result 6.45 in V6
0.75 in L6 to result 14.45 in W6
0.75 in J7 to result 12.15 in V7
0.25 in R7 to result 20.15 inR7
This is to fall in line with things already used in my workplace, otherwise I would use it as it is.
Thanks
Bookmarks