Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
If statement based on time ranges
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="joeu2004, post: 7402222"] There is no time 24:0:0. Midnight is 0:0:0. So the following is sufficient: =IF(B10<=TIME(6,0,1),100%, IF(B10<TIME(12,0,1),75%, IF(B10<TIME(18,0,1),50%,25%))) Note that in the second IF expression, we take advantage of the fact that we failed the first test. So we know that B10>TIME(6,0,1) is true; we do not need to test it. Similarly in the third IF expression. [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
If statement based on time ranges
Top
