Not sure what I'm missing, but column M ins't cooperating.
Not sure what I'm missing, but column M ins't cooperating.
Last edited by BeatBama; 02-28-2011 at 06:43 PM. Reason: solved
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)
Audere est facere
hello BeatBama
try this.
![]()
Please Login or Register to view this content.
TYVM! (how'd I miss that, lol)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks