copy,paste,calculate Cell value based on calculations & comparisonsother cells same row. Decimal places

[DocAElstein]

Hi

I do not understand your question ??
I do not understand what you want.??

If column H of 1.xls is lower than column D of 1.xls then with column K (subtract it and make it to the number ending with 0 or 5 whichever met first)
If column H of 1.xls is greater than column D of 1.xls then with column K (add it and make it to the number ending with 0 or 5 whichever met first)r

That makes no sense. ?? It is rubbish - In English it makes no sense.

Your samples do not explain anything which happens to column K as a result of H or D. You explanation and your sample data do not seem to have any relevance.
Your explanation is no use.

---

But I can get your results with some maths… All of this is based on maths for column K. I see no relevance to column H or D ??

From your data

Before	Result After
1090.69	1090.65
147.96	147.95
264.47	264.45
30.24	30.2

_____ Workbook: 1.xls ( Using Excel 2007 32 bit )

Row\Col	J	K	L	M	N	O	P	Q
1
2		1090.69	=K2*100/5	=INT(L2)	=M2*5/100	=INT(L2)*5/100	=INT(K2*100/5)*5/100
3		147.96	=K3*100/5	=INT(L3)	=M3*5/100	=INT(L3)*5/100	=INT(K3*100/5)*5/100
4		264.47	=K4*100/5	=INT(L4)	=M4*5/100	=INT(L4)*5/100	=INT(K4*100/5)*5/100
5		30.24	=K5*100/5	=INT(L5)	=M5*5/100	=INT(L5)*5/100	=INT(K5*100/5)*5/100
6

Worksheet: Tabelle1
_____ Workbook: 1.xls ( Using Excel 2007 32 bit )

Row\Col	J	K	L	M	N	O	P	Q
1
2		1090.69	21813.8	21813	1090.65	1090.65	1090.65
3		147.96	2959.2	2959	147.95	147.95	147.95
4		264.47	5289.4	5289	264.45	264.45	264.45
5		30.24	604.8	604	30.2	30.2	30.2
6

Worksheet: Tabelle1