SpreadsheetWeb
  • Features
  • Pricing
  • Blog
  • Customers
  • Try For Free
  • Sign In
    • Legacy Platform
    • SpreadsheetWeb Hub
Select Page
How to get the decimal part of numbers in a data set

How to get the decimal part of numbers in a data set

by Ilker | Apr 5, 2018 | Excel Tips & Tricks

Identifying the detail level of values in a data set can be useful for analysis of results. This simple trick can help you separate the decimal values from the numbers for evaluation. Syntax =number – TRUNC(number) (only for positive numbers) =number –...
How to shorten a number and get the integer value

How to shorten a number and get the integer value

by Ilker | Apr 5, 2018 | Excel Tips & Tricks

Do you need to shorten number, but not round them? Need to find the nearest INTeger or TRUNCate numbers in Excel? Yep, Excel has two functions that do exactly that! You can shorten numbers using the TRUNC and INT functions while preserving the original value, without...
Page 1 of 11

Recent Posts

  • How to Empower Your Business Tools: Excel vs. SpreadsheetWeb
  • What's New in SpreadsheetWeb Hub: September 2023
  • Budgeting Made Easy: How SpreadsheetWeb Hub's Family Budget Template Simplifies Your Finances
  • The Evolution of Employee Evaluations With SpreadsheetWeb Hub
  • The Power of Mutual NDA Template with SpreadsheetWeb Hub

Product

  • Features
  • Demos
  • Customers
  • Developers & API

Solutions

  • Marketing
  • Human Resources
  • Finance
  • Sales

Use Cases

  • Online Calculators
  • Sales Quoting
  • Timesheet Apps
  • Scored Questionnaires

Support

  • User Guide
  • FAQ
  • Training Videos
  • Case Studies
  • Tips

Resources

  • Blog
  • Excel Applications
  • Excel Tips & Tricks
  • Excel Formulas
  • Excel Macros
  • Excel Templates

About

  • About Us
  • Contact Us
  • Services
  • Facebook
  • Twitter

© Pagos, Inc. - All rights reserved - Privacy Policy - Terms of Use