excel formula

S

Shankar G

1 case equel to 12 packets. In my system shows 215 case and 11 packet.
My hand i have 247 case and 9 packets. How i can make a excel formula
and result should show 31 case and 10 packets. in my excel sheets
shows 31.9899 shows. any one help me to slove.
 
G

Gary''s Student

With 31.9899 in A1, in B1 enter:
=INT(A1)
and in C1 enter:
=INT(12*(A1-B1))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel formula 3
Autonumber field in Excel that behaves the same as Access 0
Numaric to Inword in excel by VB 1
Can't save my Office documents (after computer rebuild and reauthorization) 0
Little problem with this code... 11
Having Blank Cells, etc. ? 1
Migrating from Word mail merge to Access Reports 4
Count cells containing specific text when adjacent cell contains datewithin a range... 4

Top