Respected,
4
-202.15
6.9
-17.9
13
11forum.ozgrid.com/index.php?attachment/70102/
-15.38 (2.33#-0.35) 2.33 -0.35
Problem(1)
AVERAGE -0.35 should come -30~ but as mid is only considering first 3 , while A2(-202) has 4
Problem(2)
mid function IS USED AS ONLY RELEVANT NUMBERS FROM A STRING HAS TO BE CONSIDERED
BUT THIS CREATED PROBLEM WHEN THE NUMBER OF NUMERALS TO BE CONSIDERED ARE NOT ENOUGH AND HAS OTHER CHARACTER/SYMBOLS BEHIND THE SIGN(WHICH IS NORMAL)
In future the case can come where there may be character/symbols ahead of it and delimiter used is # , so if possible make that version also
So has to make formula such that only numerals that are at starting of value is considered(till 1 places after decimal, if there is decimal)
Zohar