I want to proccess from a list of values in a work sheet
Example:

Price Time

1.912,50 € 15
2.500,00 € 15
1.750,00 € 16
1.800,00 € 18
1.600,00 € 12

The Average of that values, and then Write in VBA Mode the respectiv
code for

=IF(E8<-0,5;3;(IF(E8<-0,2;2;(IF(E8<=0;1;(IF(E8<20;-1;(IF(E8<50;-2;-3)))))))))

E8 is where i have the average to simplify the VBA function


That function give me the average of the values and give me
ponderation method to choose the best proposal

--
Message posted from http://www.ExcelForum.com