I've attached a copy of the worksheet in question.
https://www.excelforum.com/attachmen...1&d=1496895930
The problem I'm having is this:
As you can see, cell F10 will total all of the values from cells C8, F8, I8, L8 & O8.
But I want to limit the value in F10 to 40 hours with any excess over 40 going to cell F11.
Is there a formula/function that will accomplish this?
Any help would be greatly appreciated.
Thanks in advance.
This should do it:
F10: =MIN(40, C8+F8+I8+L8+O8)
F11: =MAX((C8+F8+I8+L8+O8)-40, 0)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Worked perfectly. Just what I was looking for. Many thanks JBeaucaire.Originally Posted by JBeaucaire
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks