LinkBack URL
About LinkBacks
for eg I sold butter 23 pieces from the carton having 20piecesin a case so I sold 1cases and 3pieces. I need to convert in the case configuration. ie need to get a figure of 1.03 instead of 1.15
Pls help me.
for eg I sold butter 23 pieces from the carton having 20piecesin a case so I sold 1cases and 3pieces. I need to convert in the case configuration. ie need to get a figure of 1.03 instead of 1.15
Pls help me.
Last edited by jebi; 01-29-2015 at 04:38 AM. Reason: mistake in number
Perhaps =QUOTIENT(A1,20)+MOD(A1,20)/100
A1=6, B1=8, C1= need to get 1.02 (need formula in C1 to get this figure
See the attached file. Adjust the 12 in the formula to suit your pack size.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
=quotient(b6,a6)+(mod(b6,a6)/100)
or
=int(b2/a2)+(mod(b2,a2)/100)
this will work
thanks for the reply
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks