plazmatv
05-25-2018, 12:23 PM
Hello everybody!
So i cannot figure out how to make this function work.
It has to have 2 arguments
The first one is boolean and the second one is paramarray.
It has to calculate the average of the numbers in the paramarray range.
When the boolean is true , it has to control if the cells in the paramarray range contain numbers (is numeric) , and if not write an error.
When the boolean is false it should ignore what format is in the cells in the paramarray range and just calculate the average of the numbers.
I need this for school test so any little help helps.
Thanks to everyone.
So i cannot figure out how to make this function work.
It has to have 2 arguments
The first one is boolean and the second one is paramarray.
It has to calculate the average of the numbers in the paramarray range.
When the boolean is true , it has to control if the cells in the paramarray range contain numbers (is numeric) , and if not write an error.
When the boolean is false it should ignore what format is in the cells in the paramarray range and just calculate the average of the numbers.
I need this for school test so any little help helps.
Thanks to everyone.