Multiplying after the decimal point.

If I have 6.1143 in cell C19 and want to multiply this number by 35... in cell A1 I would just type =+MOD(C19,1)*35 and anything in C19 after the decimal point is multiplied by 35.

My question is this, How do I get this formula to multiply by what ever number is in C17 versus an asinged number such as 35?
for an example.

C17 has 25 in it and
C19 has 6.1143 in it

C19 is automatically multiplied after the decimal point by the given number in C17 .1143 x what ever is in C17 in this case its 25 = 2.8575

Thanks for the help
Glenn

=mod(c19,1)*c17

Faraz.Ahmed and popipipo that is exactly what I was looking for, thank you so much for your time.
I have one more question if you guys don't mind?

If I have a number 35.2571 and I multiply only the .2571 by 35 Instead of showing 8.9985 it's rounding it up to 9 how do I get to just show 8.9985 instead of rounding?

Thanks,
Glenn

Yea I tried that, I changed Format Cells to Number and tried different formatting and it stayed rounded to 9 but added some zeros behind it.

Thanks,
GS

Originally Posted by alansidman

When you change the format to numbers, change the number of decimals to 4. When I did the calculation, and left it as general it came up as 8.9985. Likewise when I change to a number with 4 decimal places

alansidman,

Thank you for your response, I did try your suggestion and it still rounds up adding 4 zeros behind my 9 such as 9.0000 vs 8.9985 I do have one cell on my sheet that is rounding up, wounder if this is causing it somehow.

here is how my sheet is laid out.

Batching Sheet






KTT# 1234567.9 WO# 12345


Species: Tomato Variety: Plant



Total weight of material: 1234 Batch Size in lbs: 35


Batch Total: =D15/G15
Number of Batches: of =ROUNDUP(C18, 0)

Batch Remainder Size: =MOD(C18,1)*G15

Treatment Type:
Primed Non-Primed


Date Batched =TODAY() INIT:



If you copy and paste that into excel it will show you what I got going on... change Total weight of material to 12345 or what ever you want and you will see the problem. How it works is you fill in total weight of material: 1234 and the Batch Size in lbs: 35 it calculates the Batch Total and that number gets rounded up giving you the number of batches. Number of Batches: of 36 the batch size in lbs is then multiplied with the Batch Totals .25714 or what ever number is in it after the math is done in the total weight and batch size. and this gives you the remaining batch total size, except its rounding up.

I hope this makes since you.

Thanks
GS

Here is the sheet I'm working on. The values on sheet 2 are carried over from sheet 1.

Batching Sheet.xlsm

Thank you for looking this over.

GS

yes I understand what you are saying but if you take 2571 and times it by 35 you get 8.9985 and the sheet rounds it up to 9, is there a way to keep 89985 with out rounding it up?

Thanks popipipo for all your help.
GS

popipipo,

When trying this formula =ROUND(D15/G15;4 in C18 I get the excel popup saying,

"it found a problem with this formula. .you type: =1+1, cell shows: 2
To get around this, type an apostrophe (') first
*you type '=1+1,cell shows: =1+1"

Thanks
GS

This was exactly what I was needing guys!
Thank you popipipo and alansidman so much for all the help!