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.
See the attached version (now a macro-enabled workbook since it contains a custom VBA function).
Sir, is this possible to solve only function?
Exactly the same if you define in name manager named function as
but the file also shall be saved as macro-enabled workbook.
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)) )
