Nested If statement???

J

jiddings

Board Regular
Joined
Nov 22, 2008
Messages
135
I have a scenario where if the first number in the series Sun thru Sat ends in either .25 or .75, it is to be rounded up to either .3 or .8 . The second number appearing as either .25 or .75 is to be rounded down to .2 or .7 .
This round up / round down would apply to as many or as little of the values that may appear ending in either .25 or .75 .

How would I construct an if statement to this round up / round down scenario? Or is there another way instead of an if statement?

Example:
Sun 8.00
Mon 4.75 round up to: 4.8
Tue 5.50
Wed 6.50
Thu 4.00
Fri 4.25 round down to: 4.2
Sat 7.75 round up to: 7.8
 
Sort by date Sort by votes
Given this scenario, what should E16 be? RU or RD?

<br /><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">13</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">dept 1</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">dept 2</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Sun</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">5.25</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CCFFCC;;">RU</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5.25</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFCC99;;">RD</td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Mon</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">5.25</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFCC99;;">RD</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5.00</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Tue</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">5.25</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CCFFCC;;">RU</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5.25</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">???</td></tr></tbody></table>

Alternate by row says it should be RU
Alternate by column says it should be RD
 
Upvote 0

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
AlphaFrog said:
Given this scenario, what should E16 be? RU or RD?


<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>A</TH><TH>B</TH><TH>C</TH><TH>D</TH><TH>E</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">13</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">dept 1</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">dept 2</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">14</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Sun</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">5.25</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ccffcc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">RU</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">5.25</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">RD</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">15</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Mon</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">5.25</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">RD</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">5.00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">16</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Tue</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">5.25</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ccffcc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">RU</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">5.25</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #cc99ff; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">???</TD></TR></TBODY></TABLE>

Alternate by row says it should be RU
Alternate by column says it should be RD
Click to expand...

The RU / RD priority should be to the row first, in this case, E16 should be RD. Of course, that doesn't allow column E to "follow the rule" of alternating RU / RD. That's how I currently understand "the rule" and I may need to further discuss with my associate.

That's what makes me question if what I'm attempting to do is feasible.

Is it possible to do alternative solution of E16 to be RU? I'll discuss the potential issues of both alternatives with my associate on Monday.

Thanks for your help
 
Upvote 0
AlphaFrog,
Further input from my associate, is clarified below:

<TABLE style="BORDER-COLLAPSE: collapse; BACKGROUND: white; mso-yfti-tbllook: 1184; mso-padding-alt: 0in 0in 0in 0in" class=MsoNormalTable border=0 cellSpacing=0 cellPadding=0><THEAD><TR style="mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #a6aab6 1pt solid; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: #e0e0f0; BORDER-TOP: #a6aab6 1pt solid; BORDER-RIGHT: #dcd9df; PADDING-TOP: 1.5pt"></TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: #e0e0f0; BORDER-TOP: #a6aab6 1pt solid; BORDER-RIGHT: #dcd9df; PADDING-TOP: 1.5pt">
A <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: #e0e0f0; BORDER-TOP: #a6aab6 1pt solid; BORDER-RIGHT: #dcd9df; PADDING-TOP: 1.5pt">
B<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: #e0e0f0; BORDER-TOP: #a6aab6 1pt solid; BORDER-RIGHT: #dcd9df; PADDING-TOP: 1.5pt">
C<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: #e0e0f0; BORDER-TOP: #a6aab6 1pt solid; BORDER-RIGHT: #dcd9df; PADDING-TOP: 1.5pt">
D<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: #e0e0f0; BORDER-TOP: #a6aab6 1pt solid; BORDER-RIGHT: #a6aab6 1pt solid; PADDING-TOP: 1.5pt">
E<o:p></o:p>

​
</TD></TR></THEAD><TBODY><TR style="mso-yfti-irow: 1"><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #a6aab6 1pt solid; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: none transparent scroll repeat 0% 0%; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df; PADDING-TOP: 1.5pt">
13<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: none transparent scroll repeat 0% 0%; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 1.5pt"></TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #dcd9df; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: none transparent scroll repeat 0% 0%; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 1.5pt">dept 1<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #dcd9df; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: none transparent scroll repeat 0% 0%; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 1.5pt"></TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #dcd9df; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: none transparent scroll repeat 0% 0%; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 1.5pt">dept 2<o:p></o:p>
​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #dcd9df; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: none transparent scroll repeat 0% 0%; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 1.5pt"></TD></TR><TR style="mso-yfti-irow: 2"><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #a6aab6 1pt solid; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: none transparent scroll repeat 0% 0%; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df; PADDING-TOP: 1.5pt">
14<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: none transparent scroll repeat 0% 0%; BORDER-TOP: #dcd9df; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 1.5pt">Sun<o:p></o:p>
​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #dcd9df; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: none transparent scroll repeat 0% 0%; BORDER-TOP: #dcd9df; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 1.5pt">
5.25<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #dcd9df; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: #92d050; BORDER-TOP: #dcd9df; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 1.5pt">
RU<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #dcd9df; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: none transparent scroll repeat 0% 0%; BORDER-TOP: #dcd9df; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 1.5pt">
5.25<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #dcd9df; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: #ffcc99; BORDER-TOP: #dcd9df; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 1.5pt">
RD<o:p></o:p>

​
</TD></TR><TR style="mso-yfti-irow: 3"><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #a6aab6 1pt solid; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: none transparent scroll repeat 0% 0%; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df; PADDING-TOP: 1.5pt">
15<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: none transparent scroll repeat 0% 0%; BORDER-TOP: #dcd9df; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 1.5pt">Mon<o:p></o:p>
​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #dcd9df; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: none transparent scroll repeat 0% 0%; BORDER-TOP: #dcd9df; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 1.5pt">
5.25<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #dcd9df; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: #92d050; BORDER-TOP: #dcd9df; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 1.5pt">
RU<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #dcd9df; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: none transparent scroll repeat 0% 0%; BORDER-TOP: #dcd9df; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 1.5pt">
5.00<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #dcd9df; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: none transparent scroll repeat 0% 0%; BORDER-TOP: #dcd9df; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 1.5pt"></TD></TR><TR style="mso-yfti-irow: 4; mso-yfti-lastrow: yes"><TD style="BORDER-BOTTOM: #a6aab6 1pt solid; BORDER-LEFT: #a6aab6 1pt solid; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: none transparent scroll repeat 0% 0%; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df; PADDING-TOP: 1.5pt">
16<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: none transparent scroll repeat 0% 0%; BORDER-TOP: #dcd9df; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 1.5pt">Tue<o:p></o:p>
​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #dcd9df; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: none transparent scroll repeat 0% 0%; BORDER-TOP: #dcd9df; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 1.5pt">
5.25<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #dcd9df; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: #fabf8f; BORDER-TOP: #dcd9df; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 1.5pt; mso-background-themecolor: accent6; mso-background-themetint: 153">
RD<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #dcd9df; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: none transparent scroll repeat 0% 0%; BORDER-TOP: #dcd9df; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 1.5pt">
5.25<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #dcd9df; PADDING-BOTTOM: 1.5pt; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BACKGROUND: #cc99ff; BORDER-TOP: #dcd9df; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 1.5pt">
RU<o:p></o:p>​


</TD></TR></TBODY></TABLE>​
<o:p></o:p>
For multiple departments, I had an incorrect interpretation, actually, B15 should be rounded up, B16 should be rounded down and E16 would be rounded up. The rule is to start with rounding up in first occurrence (of either 0.25 or 0.75), round down in the second occurrence (of either 0.25 or 0.75) and then repeat those steps for each occurrence after that when moving horizontally through each day to the end of the week.
I'm hopeful that you can help me with a formula that will work for 5 departments and throughout the week (Sunday - Saturday).
Thanks again for your help.
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Question Question
Adding to an existing MACRO
Replies
2
Views
119
Northern NY Design
N
Sandeep Warrier
  • Question Question
Calculate No. of Working Days based on Shift Pattern
Replies
2
Views
126
Tetra201
Tetra201
R
  • Solved
Overtime Formula
Replies
2
Views
416
Dave Patton
D
Vintage79
  • Solved
Count consecutive days and gaps between days
Replies
2
Views
218
Vintage79
Vintage79
R
  • Question Question
Vlookup
Replies
4
Views
546
Robert Wyatt
R

Forum statistics

Threads
1,224,586
Messages
6,179,710
Members
452,939
Latest member
WCrawford

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top