Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement based on time ranges
I am trying to ask that a percentage is returned whether a time
entered into cell B10 falls within one of four blocks of time. It is working for the first three time ranges, but the last one is giving me zero for all times entered in that range (6pm - midnight). Here is my almost working formula: =IF(AND(B10TIME(24,0,0),B10<=TIME(6,0,1)), 100%,IF(AND(B10TIME(6,0,1),B10<TIME(12,0,1)), 75%,IF(AND(B10=TIME(12,0,0),B10<TIME(18,0,1)), 50%,IF(AND(B10TIME(18,0,0),B10<TIME(24,0,1)),25%, 0)))) I think the problem is my 'false' entry, but I don't know what should be there. Can you help? Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If then statement based on time of day | Excel Programming | |||
Multiple If Then Statement based on ranges | Excel Worksheet Functions | |||
IF statement for time based data | Excel Worksheet Functions | |||
union of named ranges based only on the names of those ranges | Excel Programming | |||
Using an IF statement on time based data | Excel Discussion (Misc queries) |