Forum Discussion

Excel's avatar
Excel
Iron Contributor
Jul 12, 2021
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 large dataset? 

 

Please help..???

 

Here is a attach file..

12 Replies

    • Excel's avatar
      Excel
      Iron Contributor
      Sir, is this possible to solve only function?
      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor

        Excel 

        Exactly the same if you define in name manager named function as

        but the file also shall be saved as macro-enabled workbook.

         

Resources