- #1
hallelu01
- 3
- 0
i know this may seem to be on such a novice level and in the wrong section, but I hope someone here can help me. I was wondering if anyone can tell me how to quickly determine a range of output values, given a specific range for the input values that I can apply to any general spreadsheet. for example in excel, I have 10 values between 8 and 20 in cells A1:A10. In cell A15 I need to identify the range of the average of A1:A10. Besides trying every possible combination, is there a quick way to do this?