(SOLVED) ROUNDDOWN not rounding down...

[BeatBama]

Not sure what I'm missing, but column M ins't cooperating.

[daddylonglegs]

I think the ROUNDDOWN part works OK....but you are multiplying by C2 after the rounding, so if C2 is not an integer then the result won't be rounded, try multiplying by C2 within the ROUNDDOWN function, i.e.

=ROUNDDOWN(($D2+$D2*$K2+$E2+$E$2*L2+$F2)*$C2,0)

[dealer]

hello BeatBama

try this.

Please Login or Register  to view this content.

[BeatBama]

TYVM! (how'd I miss that, lol)