Others

How to Use Decimal Values in Microsoft Loop Rules

Maira Mehtab Sep 21, 2026 869 views

Question details

The user needs to create automated rules based on decimal values in Microsoft Loop, but the system currently only accepts whole numbers.

Product: Microsoft Loop
Device & OS: not provided
Scenario: Setting up conditions and automated rules for a Number column that contains decimal values.
Observed behavior: Microsoft Loop number columns successfully store decimal values, but the Rules function rejects them or restricts input to whole numbers only.

Before you start

Ensure your Microsoft Loop workspace is fully synced and verify that the specific column you are applying rules to is strictly formatted as a Number column.

Solution 1Recommended

Scale Decimal Values to Whole Numbers

A practical workaround to bypass the decimal limitation is scaling your decimals by a factor of 10, 100, or 1000 to convert them into whole numbers.

Since Microsoft Loop's Rules currently process whole numbers more reliably, multiplying your data by a consistent factor allows you to use the automation features without losing the relative precision of your data.

Determine a scaling factor

Identify the maximum decimal places you need (e.g., 3 decimal places means you should multiply by 1000).

Convert your values

Multiply your intended decimal value by the factor. For example, store 0.455 as 455, or 1.50 as 1500.

Input into Loop

Enter these newly scaled whole numbers into your Microsoft Loop Number column.

Create the rule

Open the Rules configuration menu and set your conditional logic using the new whole numbers.

Add a Reference Note: Consider adding a text label or column description reminding your collaborators of the scaling factor used so they can interpret the numbers correctly.

Solution 2

Use a Spreadsheet for Complex Decimal Rules

If precise decimal rules and complex mathematical logic are strictly required, shift the specific data management to a dedicated spreadsheet application.

Free Microsoft Office alternative

Handle Complex Decimal Rules Easily with WPS Spreadsheet

If Microsoft Loop's rule limitations are slowing down your workflow, consider using WPS Office. As a free and lightweight alternative, WPS Spreadsheet fully supports complex conditional formatting, precise decimal values, and advanced data validation.

1. Download WPS Office: Download and install the free WPS Office suite on your computer or mobile device.
2. Open WPS Spreadsheet: Launch the application and create a new blank spreadsheet or open an existing Excel file.
3. Set Up Decimal Rules: Select your data range, navigate to 'Home' > 'Conditional Formatting', and establish your precise rules using decimal values without any restrictions.

Fully compatible with Microsoft Excel (.xlsx) file formats.Advanced conditional formatting and rule sets for exact decimal numbers.Free, lightweight, and fast-loading spreadsheet editor.Familiar user interface makes data migration and rule setup seamless.

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't Microsoft Loop Rules accept my decimal inputs?

Currently, the Rules function in Microsoft Loop is optimized for whole numbers. While the Number column itself can store decimals, the logic engine that powers the rules does not yet fully recognize or process decimal inputs.

Will Microsoft Loop support decimal rules in future updates?

Microsoft frequently updates Loop based on user feedback. The best way to encourage the development team to add native decimal support for Rules is to click the 'Help and Feedback' menu within Loop and submit a feature request.

Can I link a WPS Spreadsheet with decimal rules into a Loop page?

While you cannot directly embed a live WPS Spreadsheet to trigger Loop's internal workspace rules, you can easily paste the file's cloud link into your Loop page. This allows your team to click and view the advanced decimal rules executing inside WPS Office.

Office Quick Solutions