V
violetwire
I have a spreadsheet that I am trying to generate a formula for ..Her
is my scenerio. I have three colums of information that will cause
person to move up and down a chart based on that info. ie. you have
middle ground then if you go up it multiplies by 100 +%..If you mov
down the chart it multiplies a total by less than 100 % depending o
how many steps down the grid. ie... yrs licd moves down grid for eac
yr someone is licd, then you move up based on next column # of yr
susp, then you move up 5 steps for every 1 claim (third column) th
4th column is the step on this grid you end on the grid has 15 steps u
and down and a ground zero in the middle. I hope I am explaining thi
well...Can you help me figure out the formula for this ...AHHHH
:rolleyes
is my scenerio. I have three colums of information that will cause
person to move up and down a chart based on that info. ie. you have
middle ground then if you go up it multiplies by 100 +%..If you mov
down the chart it multiplies a total by less than 100 % depending o
how many steps down the grid. ie... yrs licd moves down grid for eac
yr someone is licd, then you move up based on next column # of yr
susp, then you move up 5 steps for every 1 claim (third column) th
4th column is the step on this grid you end on the grid has 15 steps u
and down and a ground zero in the middle. I hope I am explaining thi
well...Can you help me figure out the formula for this ...AHHHH
:rolleyes