VBA AVERAGE/IF condition

  • Thread starter Thread starter mickey
  • Start date Start date
M

mickey

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
 
I assume you want the function listing to appear on the worksheet;

Maybe you could use the VLOOKUP function.

i.e. tabulate your IF values;

Aver Result
-0,5 3
-0,2 2
0 1
20 -1
50 -2
999 -3

Then use the VLOOKUP function to search the table and return th
result
 
Back
Top