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.

70.25	8.2	8.57
65.41	5.25	12.46
20.35	2.5	8.14

<colgroup><col width="70" style="width:53pt"> <col width="86" style="width:65pt"> <col width="96" style="width:72pt"> </colgroup><tbody>
</tbody>

 

[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