FUNCTIONS CEILING & FLOOR
CEILING
This function returns number rounded up, away from zero, to the nearest multiple of significance.
How does it work?
If you want to avoid using pennies in your prices and your product is priced at $8.48, use the formula
=CEILING(8.48,0.05)
This will round up the price from $8.48 to $8.50.
You can also give the “Cell Reference” instead of the price itself in the formula.
=CEILING(Cell_Ref,Sig)
Where,
Cell_Ref is the reference of the cell, and
Sig is the multiple to which you want to round up.
FLOOR
This function rounds number down, toward zero, to the nearest multiple of significance. This function is opposite to the CEILING function.
How does it work?
=FLOOR(8.54,0.05)
This will round down the price from $8.54 to $8.50.
You can also give the “Cell Reference” instead of the price itself in the formula.
=FLOOR(Cell_Ref,Sig)
Where,
Cell_Ref is the reference of the cell, and
Significance is the multiple to which you want to round down.
This function returns number rounded up, away from zero, to the nearest multiple of significance.
How does it work?
If you want to avoid using pennies in your prices and your product is priced at $8.48, use the formula
=CEILING(8.48,0.05)
This will round up the price from $8.48 to $8.50.
You can also give the “Cell Reference” instead of the price itself in the formula.
=CEILING(Cell_Ref,Sig)
Where,
Cell_Ref is the reference of the cell, and
Sig is the multiple to which you want to round up.
FLOOR
This function rounds number down, toward zero, to the nearest multiple of significance. This function is opposite to the CEILING function.
How does it work?
=FLOOR(8.54,0.05)
This will round down the price from $8.54 to $8.50.
You can also give the “Cell Reference” instead of the price itself in the formula.
=FLOOR(Cell_Ref,Sig)
Where,
Cell_Ref is the reference of the cell, and
Significance is the multiple to which you want to round down.
Comments
Post a Comment
Your Valuable Comments are Appreciated