Forum Discussion
Solved
Set in a whole number with the help of formulas
Hello Everyone, if there are numbers in a column like [1, 2, 3, 23, 43, 54, 34 +1, 45 - 1, 42 *2 , 34, 98] how to make this a list of whole numbers or how do we calculate in between if there is a ...
It would be very complicated without VBA.
Sir, is this possible to solve only function?
It would be very complicated without VBA.
- Ok, Thank you so much sir
As another variant formula could be
=LET(str, A1, op, {"+","-","~*","/"}, r, MMULT(COUNTIFS(str,"*"&op&"*"),{1;2;3;4}), pos, SUM(IFERROR(SEARCH(op,str),0)), lft, LEFT(str, pos-1), rht, RIGHT(str, LEN(str)-pos), IF(r=0, str, CHOOSE(r, lft+rht, lft-rht, lft*rht, lft/rht)) )- Sir , can you please explain me -
what is lft rht?
And Please explain this formula?
