Combing two formulas

Any ideas on how I can combine these 2 two formulas into one without the later one being *2:

=ROUNDUP(MMULT(D14:H14,V7:V11)/60/8,0)*2
=ROUNDUP(MMULT(I14:J14,V12:V13)/60/8,0)

Hi

I'm very confused. What do you mean by combining?

See if you will multiply the value within ROUNDUP by 2, you will get a different value that depends on the value obtained by MMULT.

Hi

Thanks for the reply, as you can tell my grasp on formulas is very limited. Please see the attached where I'm trying to create a calculator where some values are 2 and some are one, I've attached the spreadsheet which I hope will be clearer for what I'm trying to achieve.

Hi

I suppose you want this, but I am not sure.

Formula:

Please Login or Register  to view this content.

Thanks but that formula doesn't achieve what I'm after:
R14 needs to increment by 2 for every increment in D14:H14
R14 needs to increment by 1 for every increment in I14:J14

Hence my first question about combing the 2 formulas which work independently but I need them to work as one outcome in R14

Thanks for all your input and persisting while I try to convey my requirements but I'm still not there yet.

Attached is the closest I am so far but I need any 2 person job (D, F, G and I14) to increment by 2 in R14.

Essentially I have 480 mins in the 8 hr day and I need to efficiently fill that time with the correct amount of persons based on the duration of each task. As each task is reduced from the max per shift the saved minutes need to be picked up by other 1 or 2 person tasks to efficiently fill the 8 hrs with the least amount of people.

I've finally resolved the issue, many thanks for all your inputs, Reputation has been added

The answer was blissfully simple, I had the 2 separate formulas report into different hidden cells and then just did a SUM of the 2 outcomes. My knowledge is very basic for excel and the amount of knowledge here is outstanding, thanks for all the help, I'll recommend and will be back