FG

Open Office Calc - Round to 5?

Fresh3 days ago
Mar 15, 20266143 views
Confidence Score0%
0%

Problem

Is there a way I can have a cell round a number to the the nearest 5? For example, the number 114 would round to 115, or 62 would round to 60

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Open Office Calc - Round to 5?

Low Risk

Use the following formula (example for A1):

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment