formula problm...help me to make one^_^

[jaasaria]

hi guyzz ... i wanted to make a system to compute na percentage of the item sold in every days period...
here is the problem. ^_^

i have (10) item sell product
but within (30 days).. i want to get the (20%) of that item...

within the parenthesis is my variable... p
pllsss help me to get the formula..
plss help for those can understand my english... and sorry for the novice post.. thxx

[jaasaria]

hi guyzz ... i wanted to make a system to compute na percentage of the item sold in every days period...
here is the problem. ^_^

i have (10) item sell product
but within (30 days).. i want to get the (20%) of that item...

within the parenthesis is my variable... p
pllsss help me to get the formula..
plss help for those can understand my english... and sorry for the novice post.. thxx

guyzzz... kindly help me... i have my yahoo messenger.. plss add me to bbe more clariffied.. [e-mail]

thxx for the time

[aktharshaik]

I dont know whether this can help u or not, but plz take a look at the attached excel file here.

Regards
Shaik Akthar

[jaasaria]

i saw your attachment akthar. and i appreciated it .. but sorry.. it did not get my problem answer .. any one could help me.. i really need ur help...

thx for the reply..

[aktharshaik]

Can you post ur requirement more clearly. i could not get ur exact requirement.
give some exact explanation with some more sample data. is it in VB that u require this?

Regards
Shaik Akthar

[jaasaria]

hi Shaik.. yes it is in VB. i have an inventory that i wanted to get the

item quantity within the month/day period and
it percentage values(%) and define it a slow,mid, and fast moving..

for example..

i have 100 item
for 15 day i wanted to get the 50% of item sold
if the item sold within 50% so the value will be mid moving item..

and if the item sold lessthan 50% so it will be slow moving..
and if the item sold morethan 50% so it will be fast moving..

any question will be appreciated .. thhxx a lot for the reply