Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • BMI Calculator Basic Math
  • When Excel functions are not enough Excel User tips
  • Get monthly total from table with dates DATE
  • Convert 2-column into wide (column-row) table Formulas - combined functions
  • Expenses calendar, FaCal Basic Math
  • Multiple lines in cell using functions CHAR
  • Spreadsheet Compare application Excel User tips
  • The Excel “&” bug Excel User tips

Limited Ceiling

Posted on March 13, 2018 By ANmar

The function CEILING (CEILING.Math as of Excel 2016) is a very good powerful function.

It allows you to round  number to any value up

Unlike ROUND, ROUNDUP and ROUNDDOWN, that are limited to number of decimal places.

CEILING can round to any number, decimal or not.

Below is an example of rounding the number in D2 which is 22 into the next 7 up, 7 is in D3, result is 28 as you can see

Screenshot_1

 

 

But …

A challange a while back was to create what is equivelent to CEILING

So, here it is …

Screenshot_2

Using the function INT that will cutthe integer part of a number, we can easily mimic CEILING function.

 

Download Spreadsheet
Excel Online version

 

Basic Math, CEILING, Formulas - combined functions, INT, Math and Trig, Standard functions Tags:CEILING, INT

Post navigation

Previous Post: Count cells with condition – multiple conditions
Next Post: Excel ad from early 90s

Related Posts

  • Why I ran from =INDIRECT() function Formulas - combined functions
  • Multiple Dual-Validations COUNTA
  • Zipcode-State search Formulas - combined functions
  • Change Calculator – calculate change in multiple bills/coins Formulas - combined functions
  • Highlight dates dynamically AND
  • VALUE() of LEFT() Formulas - combined functions

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (82)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (5)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • Looplist – Repeating months using formulas Basic Math
  • New function IFERROR, finally IFERROR
  • Jan8 date format AND
  • Show developer tab Excel User tips
  • Excel @ before function names in formulas Excel User tips
  • Repeated Offset Basic Math
  • 6174 Kaprekar’s constant Basic Math
  • Zipcode-State search Formulas - combined functions

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme