variable for percentage
THANKS! I will.
"laavista" wrote:
I need to store the value of a percent in a variable.
The value in the cell is 48.4%.
If I change the format to a number it's
0.484320557491289
I've tried
dim ThePrecentage as long (I get a value of 0)
dim ThePercentage as integer (I get a value of 0)
dim ThePercentage as text (just to see what I got-- I got
"0.484320557491289"
Later in the procedure I will be checking to see in what range the
percentage falls, e.g., 0-39.9; 40.0 to 49.9 or 50.0+
Any help you can provide would be VERY appreciaed
|