5 answers funtion! Help!

[hellokity]

hi, I have one little work but i m realy new here in VBA world and i want to ask you all how to write this function I need to find V(Average), Min, Max and then i need to find Ddown and Dup: Ddown is the average distants of all less value numbers then V(Average). example: Ddown – integers wich is lessi then V, deviation of the average. so if V (average) is 5 and and in the range less value numbers is 2, 4 and 3, then (3+1+2)/3 = 2. The simmilar is Dup but then i need to find integers witch have bigger value then V(average). And all this should have to be one excel function wich give the ansver : for example =your function (V/Min/Max/Ddown/Dup). And it should have to look for all integer numbers range


Thanks a lot!

[arlu1201]

Hello hellokity,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.