ExcelBanter - excel formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - excel formula (https://www.excelbanter.com/excel-discussion-misc-queries/244521-excel-formula.html)

Shankar G

excel formula

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.

Gary''s Student

excel formula

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

--
Gary''s Student - gsnu200906

"Shankar G" wrote:

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.

All times are GMT +1. The time now is 07:13 AM.