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

[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]

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 )

[fixer]

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

[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

[DocAElstein]

I will look again tomorrow.
If , before tomorrow, you have explained fully , with test data what you want, then I will try to help further.

If, by tomorrow you have not explained fully what you want, then I will delete this Thread because it is full of rubbish.

Alan

---

Doc Sir what information u need plz specify that so that i can answer the same bcoz i havent understood ur question yet sir

My question is simple.

What do you want? What is your question?
So far all your explanations make no sense in English language

You tell me things about column H and D. But you do not tell me in English what is the relavance to your results and question

what does it mean...
do the subtraction
do the addition

[fixer]

Doc Sir plz give me 24hrs from now due to internet issue
i will share the sample file with all details in it
thnx for the support 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 )