Link to home
Start Free TrialLog in
Avatar of Sachin Singh
Sachin Singh

asked on

conditionally change the value after decimal

If column J is BUY Then add the number after decimal  so that the second value after decimal comes to 5 or 0  and after it comes to 0 then remove all the value after decimal second value
If column J is SELL then  subtract the number  after decimal so that the second  value after decimal comes to 5 or 0  and after it comes to 0 then remove all the value after decimal  second value

plz see the sample file
OneClick.xlsb
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

What result do you want if the the number is 1615.0114?
What result do you want if the the number is 1615.6114?
Avatar of Sachin Singh
Sachin Singh

ASKER

If column J  is BUY  then 1615.05
If column J is SELL then  1615.60
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Yes Martin Sir
But i want the vba code to do this  and change the data to column G and column L see the sample file
so plz look into it
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thnx Martin Liss  Sir and Gustav Brock  Sir for ur  Great Support
Hmm, no points for an excellent function ...
i have given both half half Sir
Great! Have a nice day.