Compare CEILING vs FLOOR

2 vs

Compare CEILING vs FLOOR side-by-side — differences, popularity and recommendation

Presets: VLOOKUP vs XLOOKUP SUM vs SUMIFS INDEX vs MATCH vs XLOOKUP IF vs IFS vs SWITCH COUNT vs COUNTA vs COUNTIF AVERAGE vs AVERAGEIF vs AVERAGEIFS MAX vs LARGE vs MIN TEXT vs TEXTJOIN vs CONCAT FILTER vs SORT vs UNIQUE ROUND vs ROUNDUP vs ROUNDDOWN

All functions Pick at least 2 functions

Feature

Math & Trig

=CEILING()

★ Winner

Syntax

Math & Trig

=FLOOR()

Syntax

Category

Math & Trig math-trig

Popularity

30 / 100

Views

◉ 42 views

◉ 37 views

Output

Number

Version

All versions

Volatile

Dynamic Array

Description

Returns number rounded up, away from zero, to the nearest multiple of significance. For example, if you want to avoid using pennies in your prices and your product is priced at $4.42, use the formula =CEILING(4.42,0.05) to round prices up to the nearest nickel.

The FLOOR function in Excel rounds a specified number down to the nearest specified multiple of significance. Negative numbers are rounded down (further negative) to nearest whole multiple below zero.

Syntax

=CEILING(number, significance)

=FLOOR(number, significance)

Arguments

2 Arguments

number significance

2 Arguments

number significance

Examples

Tips

★ Recommendation — Winner: =CEILING()

=CEILING() is recommended based on higher popularity, newer version and Dynamic Array support.

Winner: =CEILING()