tblackwell
New Member
- Joined
- Oct 24, 2018
- Messages
- 28
- Office Version
- 365
- Platform
- Windows
Newb here so bear with me if the answer is obvious!
Situation: Working on a real life business situation where we are looking at current store operating hours and deciding if we need to close early if we are doing less than $40 in sales. I can write the formula for that - no problem!
Hypothetical Example: =IF(F2<40,MOD(E2-TIME(1,0,0),1),E2). This says, I store is doing less than $40 in sales, look at the current time it closes and make it close one hour earlier (i.e. 10:00pm)
Problem: I want to add one more condition to this formula. If store is currently closing at 11:00, then I do not want it to close any earlier. Stated another way, if store is doing less than $40 in sales from 10:00pm to 10:59pm then I do not want it to close at 10:00pm, I want to keep it as is - open till 11:00pm
Current formula where I get stuck: =IF(currently closing at 11:00pm, then leave closing at 11:00pm, otherwise do this -----> IF(F2<40,MOD(E2-TIME(1,0,0),1),E2)
System: Windows 10 Pro
Appreciate any help you can provide on this formula!
<tbody>
</tbody>
<tbody>
</tbody>
Situation: Working on a real life business situation where we are looking at current store operating hours and deciding if we need to close early if we are doing less than $40 in sales. I can write the formula for that - no problem!
Hypothetical Example: =IF(F2<40,MOD(E2-TIME(1,0,0),1),E2). This says, I store is doing less than $40 in sales, look at the current time it closes and make it close one hour earlier (i.e. 10:00pm)
Problem: I want to add one more condition to this formula. If store is currently closing at 11:00, then I do not want it to close any earlier. Stated another way, if store is doing less than $40 in sales from 10:00pm to 10:59pm then I do not want it to close at 10:00pm, I want to keep it as is - open till 11:00pm
Current formula where I get stuck: =IF(currently closing at 11:00pm, then leave closing at 11:00pm, otherwise do this -----> IF(F2<40,MOD(E2-TIME(1,0,0),1),E2)
System: Windows 10 Pro
Appreciate any help you can provide on this formula!
C | D | E | F | T | U | W | Z | AA | AB | AC | AD | AE | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | STORE | PUW CLOSE SUN-THU | P10 '17-P3 '18 LAST HOUR SALES | WINTER HOURS RECCO SUN-THU | |||||||||
6 | Stuart | 11:00:00 PM | $ 64.04 | 11:00:00 PM | <-because this store does more than $40, it stays open at 11:00pm | ||||||||
8 | Nashville | 11:00:00 PM | $ 78.85 | 11:00:00 PM | <-because this store does more than $40, it stays open at 11:00pm | ||||||||
9 | Berkeley | 11:00:00 PM | $ 115.57 | 11:00:00 PM | <-because this store does more than $40, it stays open at 11:00pm | ||||||||
10 | Lillington | 11:00:00 PM | $ 38.60 | 10:00:00 PM | <-because this store does less than $40, the current formula makes it close at 10:00. However, 11:00pm is the earliest I want it to close, so how do I leave it closing at 11:00pm? | ||||||||
11 | Morehead City | 12:00:00 AM | $ 17.13 | 11:00:00 PM | <-because this store less than $40, it will close one hour earlier at 11:00pm | ||||||||
12 | Ahoskie | 11:00:00 PM | $ 104.27 | 11:00:00 PM | <-because this store does more than $40, it stays open at 11:00pm | ||||||||
13 | Williamston | 11:00:00 PM | $ 82.03 | 11:00:00 PM | <-because this store does more than $40, it stays open at 11:00pm |
<tbody>
</tbody>
Greensboro
Worksheet Formulas
<tbody> </tbody> |
<tbody>
</tbody>