Thread: Seperating decimals and numericals

I have a worksheet which contains amount, quantity and total where total is amount*quantity. The problems is that my amount contains to sub columns KD and fils, I manage to get the total but the total is not displayed in KD and fils infact the total is displayed in just one column.

Could you please help me out

Regards
Tiyara

It's hard to follow without an example of your spreadsheet and what you are trying to obtain but here's what I think you are asking for.

In one column, let's say E, you want Total Amount * Quantity.
You have Quantity in Column D so that's not a problem but amount is either
1. the sum of two columns (B and C) or
2. either column B or C, it varies.

I think in either case in column E, you could use

=(B2+C2)*D2

Sorry if I got this all wrong and I might have.

ChemistB

In D1

=INT(A1+B1)*C1

In E1

=(A1+B1)*C1-D1

Does that work for you?

ChemistB

see the attachment
here is an example for you

Okay, I looked at the attachment and it looks like you are using the formulas I suggested. What is it not doing that you want it to do?

ChemistB

Hi,

Thank you for all the help, I managed to get the problem solved...

Attached is a sample of the excel sheet i was looking for, maybe you could help me modify it in a better way.

Regards
Tiyara

Try this:

H9

=INT((G9/1000+F9)*E9)

I9

=1000*((G9/1000+F9)*E9-H9)

Thank you for your reply ...both the codes are working perfectly fine...appreciate all the help

Regards
Tiyara