**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need a formula for a resource planning model that will round up if a given number is odd to the next whole number of team size.

Solved by E. E. in 22 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
05/02/2018 - 09:31

hello

User
05/02/2018 - 09:31

hi how are you?

Excelchat Expert
05/02/2018 - 09:32

hi, good, so can you share the file please

User
05/02/2018 - 09:32

one sec

Excelchat Expert
05/02/2018 - 09:32

sure

User
05/02/2018 - 09:34

can you see it?

Excelchat Expert
05/02/2018 - 09:34

yes

User
05/02/2018 - 09:35

basically, i am trying to create a staffing model

User
05/02/2018 - 09:35

if the number of campaigns is odd (row 3)

User
05/02/2018 - 09:36

then the number of resources required should round up so the staffing is the same as the next highest even number

User
05/02/2018 - 09:36

so, the total number of resources required would be the same for 1 and 2 campaigns, 3 and 4 campaigns, 5 and 6 campaigns, etc

User
05/02/2018 - 09:37

however i cant seem to figure it out

Excelchat Expert
05/02/2018 - 09:37

let me see

User
05/02/2018 - 09:38

thanks

Excelchat Expert
05/02/2018 - 09:39

can you create a scenario where the odd number comes and you need to round up

User
05/02/2018 - 09:40

sure

User
05/02/2018 - 09:40

if there is one campaign, there should still be 8 total resources required (8)

User
05/02/2018 - 09:41

this is because the team size is always 8

Excelchat Expert
05/02/2018 - 09:42

what is the campaigns per team's role here?

User
05/02/2018 - 09:42

that is their capacity

User
05/02/2018 - 09:42

so, each team can handle 2 campaigns

User
05/02/2018 - 09:42

however, if there is an odd number of campaigns, like 1, a full team is still required

User
05/02/2018 - 09:43

so that should be 8 in this example

Excelchat Expert
05/02/2018 - 09:44

Ok so basically what you need is same resource for 1&2...3&4...5&6...and so on?

User
05/02/2018 - 09:44

yes exactly

Excelchat Expert
05/02/2018 - 09:46

https://docs.google.com/spreadsheets/d/1xoJPNPT4-tixp4Zexzt_wUgYMLru1LgedeOSkmWcoCU/edit#gid=0

Excelchat Expert
05/02/2018 - 09:46

Check

Excelchat Expert
05/02/2018 - 09:47

https://docs.google.com/spreadsheets/d/1xoJPNPT4-tixp4Zexzt_wUgYMLru1LgedeOSkmWcoCU/edit?usp=sharing

Excelchat Expert
05/02/2018 - 09:47

click on the second link please

User
05/02/2018 - 09:48

nice how did you do that?

Excelchat Expert
05/02/2018 - 09:48

first i checked the team number with ISODD function

Excelchat Expert
05/02/2018 - 09:49

then I embeded the result in a IF

Excelchat Expert
05/02/2018 - 09:49

If ISODD then I increased the value of the cell by 1 such that it acts like an even

Excelchat Expert
05/02/2018 - 09:49

And IF not then as it is

User
05/02/2018 - 09:50

ah got it

Excelchat Expert
05/02/2018 - 09:50

:)

User
05/02/2018 - 09:50

thank you

User
05/02/2018 - 09:50

this was really helpful

Excelchat Expert
05/02/2018 - 09:50

If you leave please end the chat from your end and give me ratings

Excelchat Expert
05/02/2018 - 09:50

thanks

User
05/02/2018 - 09:51

will do thanks

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*