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

[fixer]

Thnx Alot Doc Sir for helping me in solving this problem

[fixer]

all file are located in a different path
vba code will be placed in a seperate file macro.xlsm
my file name is 1.xls
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)
i have attached the sample file and result too.. plz have a look sir
and help me in solving this problem sir

[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

[fixer]

Column H & Column D has relation bcoz Either Market can Move Up Or Down ,I have to Buy shares Or i have to sell shares
& why i need macro is
1090.69
147.96
264.47
30.24

After decimal if the number doesnt ends with .05 or .0 then that order is not accepted by system

[DocAElstein]

That does not explain anything about the question you asked. Once again we have the problem that you cannot communicate in English language.

I still do not understand
I still do not understand the relevance to the question http://www.excelfox.com/forum/showth...ll=1#post13074 . … I see not relation to your test data in H and D and the results which you ask for

I have no idea what you are asking for.
I have given you the results you asked for, but it has nothing to do with anything in column H and D. My results are what you asked for, but I do not consider anything in column H and D.

[fixer]

if column H of 1.xls is lower than column D of 1.xls then with column K do the subtraction after decimal and make it to the number ending with 0 or 5 whichever met first & if it ends with .05 or .00 then ignore that cell
If column H of 1.xls is greater than column D of 1.xls then with column K do the addition after decimal and make it to the number ending with 0 or 5 whichever met first and if it ends with .05 or .00 then ignore that cell

this is the conditon Doc Sir

[DocAElstein]

Sorry, I do not understand
What you wrote makes no sense in English.

Try to explain again with lots more detailed data.

Your screenshots are almost useless. They explain only the problem which I answered. They explain nothing about column H or D. They show only a change in column K. There is no explanation from you about the relavance to the question and column H or D.

You explanations so far are almost useless. They say almost nothing. Or they make no sense.. what does it mean...
do the subtraction
do the addition

[fixer]

Doc Sir as u said u understood the problem
so plz help me to solve this problem Sir

[fixer]

column H is a Last traded price & column D is a opening price
from this we came to know about market is moving up or moving down in that situation , u cant rely on high or low bcoz it always makes a new high & new low
Doc Sir what information u need plz specify that so that i can answer the same bcoz i havent understood ur question yet sir

---

Moderator Translation:
I am a total fucking idiot dim pig shit for brains, so just give me a macro that does what I want, even though most of the time I aint got a fucking clue myself what I want because I am such a total fucking spacko ... and never mind anyway, fuck off you mug, as some other twat gave me a macro at one of my many duplicated cross postings.......( Intro to Avinash Singh... https://excelfox.com/forum/showthrea...h-Introduction )

[DocAElstein]

It is almost impossible to communicate with you.

---

You are telling me things which appear to have no relevance to your question.
This I understand:
… column H is a Last traded price & column D is a opening price
from this we came to know about market is moving up or moving down in that situation , u cant rely on high or low bcoz it always makes a new high & new low
But I see no relevance to the question??


It is impossible to help you further. I cannot guess what you want.

Doc Sir as u said u understood the problem
so plz help me to solve this problem Sir

No . I did not say that. I do not understand the problem !!!!
what does it mean...
do the subtraction
do the addition