Excel - IF Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.