Excel - IF Function Problem - Expert Solution

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

I have a schedule for my colleagues and I would like excel to automatically remove their break time from the allocated hours I have inputted for that week, based on the amount of hours they have set within that day. So if they're doing 4 hours, they get no break. If they're doing between 5 to 8 hours, they get 30 minutes. 9 hours or more they get 45 minutes.
Solved by S. J. in 52 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 22/09/2018 - 12:40
Excelchat Expert 22/09/2018 - 12:40
Welcome to Excelchat, I see that your question is about formulas
User 22/09/2018 - 12:40
Sorry the questions I was given I cannot seem to answer
User 22/09/2018 - 12:40
So I thought it ended
User 22/09/2018 - 12:40
Yes that is correct :)
Excelchat Expert 22/09/2018 - 12:40
Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.
Excelchat Expert 22/09/2018 - 12:41
Let me ask you a couple of quick questions to make sure I fully understand your problem.
Excelchat Expert 22/09/2018 - 12:41
Can you tell me the high-level goal you are trying to achieve?
User 22/09/2018 - 12:41
Not sure I understand the question?
User 22/09/2018 - 12:42
Oh, as in my main goal I'm trying to achieve
Excelchat Expert 22/09/2018 - 12:42
Excelchat Expert 22/09/2018 - 12:42
Do u have a sample document so I can address to your problem?
User 22/09/2018 - 12:42
Basically, I have a small little bar and I no longer pay for my staff breaks
User 22/09/2018 - 12:42
But, I don't want it to take it off what I allocate my hours for that week
User 22/09/2018 - 12:43
Yeah sure
Excelchat Expert 22/09/2018 - 12:43
Thank you, I'll wait for it
Excelchat Expert 22/09/2018 - 12:44
Based on what you've shared, you need a formula using if statement
User 22/09/2018 - 12:45
Excelchat Expert 22/09/2018 - 12:45
I understand what the question is, I’ll start working on the solution and will be updating you as I work.
User 22/09/2018 - 12:45
Okay lovely, thank you so much
Excelchat Expert 22/09/2018 - 12:45
This should take me 30mins or less.
User 22/09/2018 - 12:46
As I've copied it across I don't think the formulas would've copied correctly
Excelchat Expert 22/09/2018 - 12:47
Can you just add the file using the paper click at the right of your chat box
User 22/09/2018 - 12:47
There we go, no it's got it.
User 22/09/2018 - 12:47
The allocation is at the bottom
Excelchat Expert 22/09/2018 - 12:47
Paper clip*
User 22/09/2018 - 12:49
Two seconds
Excelchat Expert 22/09/2018 - 12:50
Use the paper clip at the right or your chat box to send the file
Excelchat Expert 22/09/2018 - 12:50
So I can fully understand your goal
User 22/09/2018 - 12:50
Yeah just removing names quickly
Excelchat Expert 22/09/2018 - 12:52
Ok, wait
Excelchat Expert 22/09/2018 - 12:53
is you c9 value equal to 0 or 8?
Excelchat Expert 22/09/2018 - 12:55
what is your initial value in target replen?
Excelchat Expert 22/09/2018 - 12:56
Excelchat Expert 22/09/2018 - 12:56
Are you still there?
Excelchat Expert 22/09/2018 - 01:23
Since you lack in information, this is the best thing that I can only do.
[Uploaded an Excel file]
Excelchat Expert 22/09/2018 - 01:25
The formula states that if the value in S (Cell C4) is equal to or lesser than 4 it will give a value which is 0.
Excelchat Expert 22/09/2018 - 01:27
While if the value in S (Cell C4) is equal to or lesser than 8 it will give a value which is 30.
Excelchat Expert 22/09/2018 - 01:28
Else, it will give a value which is 45.
Excelchat Expert 22/09/2018 - 01:28
That goes the same with the other cells.
Excelchat Expert 22/09/2018 - 01:29
I also give additional table if you are using a number of hours.
Excelchat Expert 22/09/2018 - 01:31
Thanks for coming to Excelchat. Feel free to leave any comments or feedback. Have a nice day.

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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc