If then add

[billandrew]

Good afternoon all

Dividing the below, when the result is greater than 8 add .5 to the divisor and then divide the dividend by the new divisor.

[TABLE="width: 252"]
<colgroup><col width="70" style="width:53pt"> <col width="86" style="width:65pt"> <col width="96" style="width:72pt"> </colgroup><tbody>[TR]
[TD="width: 70, align: right"]70.25[/TD]
[TD="width: 86, align: right"]8.2[/TD]
[TD="width: 96, align: right"]8.57[/TD]
[/TR]
[TR]
[TD="align: right"]65.41[/TD]
[TD="align: right"]5.25[/TD]
[TD="align: right"]12.46[/TD]
[/TR]
[TR]
[TD="align: right"]20.35[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: right"]8.14[/TD]
[/TR]
</tbody>[/TABLE]

 

[Dryver14]

untested but you could try wrapping the whole thing in an if statement

=IF(IF(A1/B1>8,A1/(B1+ROUNDUP((A1/8-B1)/0.5,0)*0.5),A1/B1)>8,8,IF(A1/B1>8,A1/(B1+ROUNDUP((A1/8-B1)/0.5,0)*0.5),A1/B1))

 

[billandrew]

Mr. wideboydixon

WOW! Thank You for trying to interpret my need and sticking with me.

The shifting requirement comment by the way is hilarious....

Regards

 

[billandrew]

Going to try this one out.

Thanks