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