Excel - How to separate a decimal point into a separate column

Hello
adds a picture of a simplified account


Well, after entering some numbers in the PLN column and some numbers in the gr column, count it for me. Please help

Welcome,
Assumptions: I lost zlotys in column B (B2: B4), pennies in C (C2: C4)

In B5 the formula: = ROUND TOTAL ((100 * SUM (B2: B4) + SUM (C2: C4)) / 100)
In C5, the formula: = VALUE (RIGHT (SUM (C2: C4), 2))

I get zlotys by adding up all zlotys and converting them into pennies (multiplication x100), then I add the sum of pennies and (already having the sum of pennies) I divide everything by 100. The decimal part is removed (rounded down).

Pennies a bit easier - we sum them up, but to eliminate the result greater than 100 we only use the last two digits in the result (right function). As the result is then a text value, I convert it back to a number (value function).

That was it?

It would be advisable if you would do it in Excel and make a screen for me and insert it?
Because it's a bit hard for me to get it like this

This is what it looked like for me:

Something is wrong with me in the entire sheet and how could you apply it in it, save it and then insert it.
http://przeklej.net/file_details/88780.html

I will not do homework for my friend. I will suggest that my formulas count completely different than what my friend wants to count. First, I propose to focus on the first stage - how to obtain value from the unit price and quantity (if it were not broken down into two columns with zlotys and pennies separately, it would be trivial). My functions were to count only what is in the large field TOGETHER, but taking into account that it is one field (without breaking into zlotys and pennies), you can (and even have to in this situation) simplify it.

My tips for solving the problem:
First, enter pennies as a whole (i.e. numbers from 0 to 99, not 0, xx). Second, you can customize penny cells to display the leading zero.
To count zlotys and grosze, you can use the functions from my first answer, but you need to rewrite them a bit (e.g. insert multiplication instead of the sum).

In case of problems, ask.

so yes = ROUND TOTAL ((100 * SUM (F14: F16) * (F14: G18)) / 100)?
so I entered the value in pennies in the column
Just something's not working

It doesn't work because you are guessing and not trying to think what you want to achieve.
Let's start with pennies. Let's deal with the first row (cell J18). To get the number of pennies, you have to multiply the quantity by the unit price. Even better, you can just multiply the quantity by the penny unit, or the zloty will not change the result. And that could be enough, but sometimes more than 100 groszy will come out, which is unacceptable. as you know, multiples of 100 groszy will add up, but as zlotys, so you can, apart from the two numbers on the right, cut everything off before them. So I propose a function similar to (insert cells as they should be):

= [quantity] * [unit_pence]

To round this to two places (that is, truncate the full hundreds):

= RIGHT ([quantity] * [unit_pence]; 2)

The right function gives a text value, so that there is a number in the cell suitable for further calculations, it must all be closed in the VALUE function:

= VALUE (RIGHT ([quantity] * [unit_pence], 2))

instead of [quantity] and [unit_pence] insert the address of the appropriate cell, that is for the first line F18 and H18 for example.

For me, it's black magic: / I'm playing too little with this program, so I don't understand anything. I just got this task and I can't cope with it and what you gave me above does not bother me

Introduce the formula from cell F18, we'll see what's wrong.

= VALUE (RIGHT (E14 * G14) / 2)

You have the same E14 and G14 as the buyer's address. Besides, you wouldn't be able to validate this formula, because excel would report an error. You were supposed to insert cells containing quantity and pennies per unit price. Apart from that, you didn't even bother to rewrite the exact formula that I already gave you as a prefix (the semicolon in the RIGHT function and the division do different things).

Hope you won't get any credits in this subject as it's not looking good.

It should probably look something like this:

This is exactly what it is supposed to be like
They do not coincide, but for me, E14 is an amount and G14 are pennies in the unit price. I even don't have the strength to see today if it works for Exel, I have a laptop and currently I am sitting on the phone. As for the pass, these are the ready-made tasks that the teacher gave and only changed them a bit, in the next lesson I will tell you to explain it exactly.

See, just fix the function as I wrote before.
And try it with PLN:
Assuming further the first pattern with line 18, the formula looks something like this:

= ROUND.TOTAL ([quantity] * ([PLN_unit_price] + ([grosz_unit_price] / 100)))

Thanks, it works
I was trying to do something to now count everything in the column together but it comes out poorly. Would you tell me what to use?

Added after 31 [minutes]:

I figured it out and did this function, I used = SUM (H14: H16) + (I14 + I15 + I16) / 100

thank you so much for help

It can be such a function or it can be = SUM (H14: H16) + SUM (I14: I16) / 100. But overall it was about it.