NukedWhale
01-23-2009, 09:34 AM
I have a simple calculation that I need to perform MANY times (upwards of 30-40K).
I have whole numbers in rows (30-40k rows) of column C, the numbers can be anything from 0 to 20k.
I need to divide that number by a number stored in another variable (MyRows). This number will be a whole number between 0 and 40 k. I want the value result of that division in column d.
So if:
C1=10 and MyRows=100 then D1=0.1
C2=20 and MyRows=100 then D2=0.2
Example data layout attached. Let me know if you have any questions or need clarification.
Thanks
I have whole numbers in rows (30-40k rows) of column C, the numbers can be anything from 0 to 20k.
I need to divide that number by a number stored in another variable (MyRows). This number will be a whole number between 0 and 40 k. I want the value result of that division in column d.
So if:
C1=10 and MyRows=100 then D1=0.1
C2=20 and MyRows=100 then D2=0.2
Example data layout attached. Let me know if you have any questions or need clarification.
Thanks