averge of a text value

[CJP]

hello I need to get 1- the average of a text field, delimited by "+" 2- the largest of the series 3- the smallest of the series
ex 10+20+30+40+50

Thanks

[dbaum]

SPLIT() - AppSheet Help

AVERAGE() - AppSheet Help

MAX() - AppSheet Help

MIN() - AppSheet Help

[WillowMobileSys]

You will want to look at the EXTRACTNUMBERS()  and COUNT() function. Then you can do this:

SUM(EXTRACTNUMBERS("10+20+30+40+50")) / COUNT(EXTRACTNUMBERS("10+20+30+40+50"))

And then use MIN() and MAX() in a similar way as suggested by @dbaum 

EDITED:  I guess you can just use the AVERAGE() function.  I didn't remember it was there...

AVERAGE(EXTRACTNUMBERS("10+20+30+40+50")) 

I hope this helps!