# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Hi. I'm trying to model the roll out of an activity over a number of years. The total number to be rolled out is fixed. Say at 10,000. So if the roll out period is 5 years, then it'll be 2000 per year. But if I want to change the 5 to a 4, all 10k will have been rolled out in years 1-4, and year 5 will have no roll out (and no cost associated with roll out). If the roll out is 6 months, they are all rolled out in y1. I'm trying to find a way of modelling this. Can you help?
Solved by D. E. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 06/09/2017 - 02:29
Hi, Thank you for using Got It Pro. I’m happy to be able to help you today.
User 06/09/2017 - 02:31
ok what do you want from me?
User 06/09/2017 - 02:32
This is easy enough. But what if I want to change the 5 to a 4?
Excelchat Expert 06/09/2017 - 02:33
Sure on it
User 06/09/2017 - 02:33
How do I make it so that years 1-4 give me 2500, and y5 0
Excelchat Expert 06/09/2017 - 02:35
ok Try now
User 06/09/2017 - 02:36
ok that works for roll out periods of over 1. What if its 6 months?
User 06/09/2017 - 02:36
By the way, v impressive
User 06/09/2017 - 02:36
!
Excelchat Expert 06/09/2017 - 02:36
we'll have to divide the intervals into the least value you want to roll out with
User 06/09/2017 - 02:38
Ok
User 06/09/2017 - 02:38
So I couldn'ave have intervals of a year if I wanted to reserve the option of putting in .5 yeras as a roll out period?
Excelchat Expert 06/09/2017 - 02:38
you could
Excelchat Expert 06/09/2017 - 02:39
but it will give the same result as 1 year
User 06/09/2017 - 02:39
ok I think that should probably be ok
User 06/09/2017 - 02:39
So talk me through what you've done?
Excelchat Expert 06/09/2017 - 02:39
sure
Excelchat Expert 06/09/2017 - 02:40
first thing
Excelchat Expert 06/09/2017 - 02:40
row 6
Excelchat Expert 06/09/2017 - 02:40
is to adjust the number of years shown
Excelchat Expert 06/09/2017 - 02:40
I used an embedded if statement
Excelchat Expert 06/09/2017 - 02:40
1st one to check the the number of years if larger than the roll out period then enter 0
Excelchat Expert 06/09/2017 - 02:40
second one is because it's a sequence
Excelchat Expert 06/09/2017 - 02:41
so the next cell after 0 will return 0+1 which is smaller than the roll out period and will show a value
Excelchat Expert 06/09/2017 - 02:41
which will result in a sequence like in row9
Excelchat Expert 06/09/2017 - 02:42
so to break that I used another if statement if the cell before you is 0 then enter 0
Excelchat Expert 06/09/2017 - 02:42
next is the amount rolled out
Excelchat Expert 06/09/2017 - 02:42
you got the concept right when you did it yourself
User 06/09/2017 - 02:42
ok but I want to model all 5 years regardless. i.e. I don't want year 5 to disappear if roll out is over 4 years. Will that happen?
Excelchat Expert 06/09/2017 - 02:42
but you needed to insert some boundaries
Excelchat Expert 06/09/2017 - 02:42
no that will not happen
Excelchat Expert 06/09/2017 - 02:43
you could just enter in D6 =C6+1
Excelchat Expert 06/09/2017 - 02:43
and drage
Excelchat Expert 06/09/2017 - 02:43
drag*
Excelchat Expert 06/09/2017 - 02:43
no need for the if statements then
Excelchat Expert 06/09/2017 - 02:43
only thing is when you enter a value larger than 5
Excelchat Expert 06/09/2017 - 02:43
you will have to redrag to add 6 to the range
User 06/09/2017 - 02:43
This is awesome. HOw does this work? Can I save this chat? I haven't got everything and will need to go over it afer our time is up!
Excelchat Expert 06/09/2017 - 02:44
does this make sense?
Excelchat Expert 06/09/2017 - 02:44
first off you can extend the session 20 minutes
Excelchat Expert 06/09/2017 - 02:44
you will be given the option when we hit the 2 minute mark
Excelchat Expert 06/09/2017 - 02:44
then as for the chat history let me check now with the technical team and get back to you
User 06/09/2017 - 02:45
Sort of. How does the service work? This is m y first time
Excelchat Expert 06/09/2017 - 02:45
ok first time is free
Excelchat Expert 06/09/2017 - 02:46
User 06/09/2017 - 02:46
and then?
Excelchat Expert 06/09/2017 - 02:46
as for the chat history it won't be accessible nor the file if you do not download it
Excelchat Expert 06/09/2017 - 02:47
everything is deleted to maintain the customer's confidentiality of data and anonymity
User 06/09/2017 - 02:48
Ok. so I've downloaded now. Have 2 mins left. I will probably need to come back with another question before long. Have been given an assignment which is a bit beyond my skill set!
User 06/09/2017 - 02:48
So I buy credits, is that right?
Excelchat Expert 06/09/2017 - 02:48
yes
Excelchat Expert 06/09/2017 - 02:48
you can buy one session for \$3.99
Excelchat Expert 06/09/2017 - 02:48
you have the option to extend the session
Excelchat Expert 06/09/2017 - 02:48
1 session (16 credits) for \$3.99 3 sessions (48 credits) for \$9.99 15 sessions (240 credits) for \$44.99
User 06/09/2017 - 02:48
And how much time will 3.99 give me?
User 06/09/2017 - 02:49
or credits / time.
Excelchat Expert 06/09/2017 - 02:49
16 credits give one question
Excelchat Expert 06/09/2017 - 02:49
or one session
User 06/09/2017 - 02:49
ok I guess I can look into this by myself. About to run out of time. Many thanks for your time! awesome service

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.