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
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
ASKER
If column J is BUY then 1615.05
If column J is SELL then 1615.60
If column J is SELL then 1615.60
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thnx Martin Liss Sir and Gustav Brock Sir for ur Great Support
Hmm, no points for an excellent function ...
ASKER
i have given both half half Sir
Great! Have a nice day.
What result do you want if the the number is 1615.6114?