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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hello Saqib Husain, Syed,
I want to ask you about this line of the code
Thank you
I want to ask you about this line of the code
If ctr > 1000 Then End: Stop
What do you mlean by 1000 is it a limit of calculation?Thank you
ASKER