Hello. I would appreciate if someone could help me to combine the SUM function and the round function such that every time I have a sum of 0.6,to round it up to 1. So, for example if I have 1.2 + 1.4, I don't want it to give me 2.6,but 3. Thank you!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
SUM and ROUNDUP formulae combination
So I managed to compute the overtime,but could you help me modify the formula such that it subtracts the hours less than 6?
For example I have the overtime hours = 25
but there were 5 days with 0 work hours = 30
plus 2 more days with less than 6 which together are 1h
that means 31 h need to be worked
after subtracting the the hours from the overtime,I am left with -6 h
I could do this manually,but I want to know if there is a possibility to do it automatically
=IF(D3>E3,(D3-E3),0)
[
For example I have the overtime hours = 25
but there were 5 days with 0 work hours = 30
plus 2 more days with less than 6 which together are 1h
that means 31 h need to be worked
after subtracting the the hours from the overtime,I am left with -6 h
I could do this manually,but I want to know if there is a possibility to do it automatically
=IF(D3>E3,(D3-E3),0)
Upvote
0
Excel Facts
What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,795
- Office Version
- 365
- Platform
- Windows
I am not sure I understand. It appears that you posted a formula.
You could also use the MAX formula to replace the one you posted like I did in my previous post, to make sure it does not go negative, i.e.
You could also use the MAX formula to replace the one you posted like I did in my previous post, to make sure it does not go negative, i.e.
Code:
=MAX(D3-E3,0)
Upvote
0
Similar threads
- Question
