M
mickey
I want to proccess from a list of values in a work sheet
Example:
Preço Tempo
1.912,50 € 15,25
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.
Could someone help me
Example:
Preço Tempo
1.912,50 € 15,25
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.
Could someone help me