Have this formula to calculate pieces per carton (roundup) and the total of cartons:
=ROUNDUP(F99/352,0)+ROUNDUP(H99/135,0)+ROUNDUP(J99/110,0)
But this calculation should only be performed if the P cell in the row is blank. The rounding must be maintained. What would be the best formula for this?
Last edited by peri1224; 01-11-2010 at 12:45 PM.
=if(p99<>"", "", roundup(f99/352, 0) + roundup(h99/135, 0) + roundup(j99/110, 0) )
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks