Nov 9, 2021 #1 sal21 Programmer Joined Apr 26, 2004 Messages 500 Location IT Paraph i'm stupid... i have a STOCK(in pieces)=5000, and i have sold 140 pieces, how to calculate the percentage? the var are STOCK, and PIECES
Paraph i'm stupid... i have a STOCK(in pieces)=5000, and i have sold 140 pieces, how to calculate the percentage? the var are STOCK, and PIECES
Nov 9, 2021 #2 Andrzejek Programmer Joined Jan 10, 2006 Messages 8,576 Location US (PIECES / STOCK) * 100 Code: Dim intSTOCK As Integer Dim intPIECES As Integer intSTOCK = 5000 intPIECES = 140 Debug.Print (intPIECES / intSTOCK) * 100 & "%" We don’t call people ‘stupid’, we call them ‘special’… ---- Andy "Hmm...they have the internet on computers now"--Homer Simpson Upvote 0 Downvote
(PIECES / STOCK) * 100 Code: Dim intSTOCK As Integer Dim intPIECES As Integer intSTOCK = 5000 intPIECES = 140 Debug.Print (intPIECES / intSTOCK) * 100 & "%" We don’t call people ‘stupid’, we call them ‘special’… ---- Andy "Hmm...they have the internet on computers now"--Homer Simpson
Nov 10, 2021 #3 Andrzejek Programmer Joined Jan 10, 2006 Messages 8,576 Location US Hello...? Did that work for you? ... Anybody here... ---- Andy "Hmm...they have the internet on computers now"--Homer Simpson Upvote 0 Downvote
Hello...? Did that work for you? ... Anybody here... ---- Andy "Hmm...they have the internet on computers now"--Homer Simpson
Nov 10, 2021 #4 S SkipVought Programmer Joined Dec 4, 2001 Messages 47,492 Location US sal21 has a bad habit of leaving a conversation hanging and not responding after a previous response. It sure does not help other members who like to browse these forums and pick up good tips. Skip, Just traded in my OLD subtlety... for a NUance! "The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein You Matter... unless you multiply yourself by the speed of light squared, then... You Energy! Upvote 0 Downvote
sal21 has a bad habit of leaving a conversation hanging and not responding after a previous response. It sure does not help other members who like to browse these forums and pick up good tips. Skip, Just traded in my OLD subtlety... for a NUance! "The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein You Matter... unless you multiply yourself by the speed of light squared, then... You Energy!
Nov 10, 2021 #5 M mintjulep Technical User Joined Aug 20, 2004 Messages 1,562 Location JP Perhaps sal21 is a devote Marxist. They do appear quite needy. Karl Marx said: From each according to his ability, to each according to his needs. Click to expand... Upvote 0 Downvote
Perhaps sal21 is a devote Marxist. They do appear quite needy. Karl Marx said: From each according to his ability, to each according to his needs. Click to expand...
Nov 10, 2021 Thread starter #6 sal21 Programmer Joined Apr 26, 2004 Messages 500 Location IT tks Andrzejek, your code work fine! sorry but busy... Upvote 0 Downvote