Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA AVERAGE/IF condition
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA AVERAGE/IF condition
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 -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average with Condition | Excel Worksheet Functions | |||
How to average values based on a condition in another column | Excel Worksheet Functions | |||
Using average in two condition arrays... | Excel Worksheet Functions | |||
formula to calculate the average of a range basing on condition | Excel Worksheet Functions | |||
Can I sum or average a range with more than 1 condition? | Excel Discussion (Misc queries) |