Skip to main content
15-Moonstone
Jan 7, 2026 8:36 AM UTC
Solved

Mean-Max- Min functions for vectors

Hi everyone, 

I have this function that I used to find R from it 

YA_10963798_3-1767774598458.png

 

Now I want to find the min, max and max  from it ..but didn't work . It tells me that the values should be scalar 

YA_10963798_4-1767774690540.png

 

and when I do this , it gives me the same results of the original one not the average

YA_10963798_2-1767774017156.png

I need to find the min, average , and max values

Thanks 

Yusra 

 

LucMeekesAnswer
23-Emerald V
Jan 7, 2026 11:12 AM UTC

You may need to recalculate the sheet.

 

Success!
Luc

8 replies

23-Emerald V
Jan 7, 2026 9:54 AM UTC

Hi Yusra,

Your z.tips is a range, not a vector. Applied to a function that makes the function result a range at best, but not a vector.

 Try making z.tips a vector, e.g. with:

LucMeekes_0-1767779509130.png

and vectorise your expression:

LucMeekes_1-1767779616997.png

Success!
Luc

Translate
15-Moonstone
Jan 7, 2026 10:15 AM UTC

It didn't work, do you think I'm missing something?

YA_10963798_0-1767780867140.png

YA_10963798_1-1767780887806.png

 

Translate
23-Emerald V
Jan 7, 2026 10:25 AM UTC

Don't vectorise the other expression:

LucMeekes_0-1767781520463.png

Success!

Luc

Translate