Link to home
Start Free TrialLog in
Avatar of Adil Kh
Adil Kh

asked on

Function: Stock calculation with decimals

Hello @Saqib Husain, Syed hello everyone,

I am refering to the genius solution of Saqib Husain, Syed concerning the stock calculation https://www.experts-exchange.com/questions/29096373/Stock-cost-error.html.
And I want to ask you how to modify the code in order to accept also the quantity as number with decimals; three decimal digits. for example 125,586.  The decimal symbol I have is my Excel software is","  that Saqib Husain, Syed had adapted the code for me.

Please find attached the file

Thank you
Draft1.xlsm
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan 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
Avatar of Adil Kh
Adil Kh

ASKER

Thank you Saqib Husain, Syed thank you all
Avatar of Adil Kh

ASKER

Hello Saqib Husain, Syed,

I want to ask you about this line of the code
If ctr > 1000 Then End: Stop

Open in new window

What do you mlean by 1000 is it a limit of calculation?

Thank you