formula help

[ali zaib]

i enter in cell A1 24.12 and enter in A2 24.12 i want to see result 49
24 are the number of cases and 12 show number of bottles 24 bottles are in one case now 24.12 and 24.12 can show result 49 cases

 

[MrKowz]

I am incredibly confused. Can you please provide several examples of what you want along with their examples?

 

[VoG]

Maybe like this

Excel Workbook
	A
1	24.12
2	24.12
3	49
Sheet4

 

[ali zaib]

thanks sir for your early response

 

[Jonmo1]

Assuming Niether decimal will be more than .23, otherwise the whole number would go up 1, and the decimal to 0..

Also assuming the decimal may be up to 23, and you want the remainder added back in..

LIke 24.15 + 24.17 = 49.08 (15+17 =32, - 24 = 8)

Also assuming, that 24 cases and 8 bottles would be written as

24.08 (NOT 24.8)


Try

=INT(SUM(A1:A2))+INT(MOD(SUM(A1:A2),1)/0.24)+(MOD(MOD(SUM(A1:A2),1)/0.24,1)*24/100)