Panduan pengguna Ulet

Mulai menggunakan Ulet untuk Mac.

Label Rows With an IF Formula in Ulet on Mac

An IF formula can add a readable label based on a quantity. This example marks supplies below a reorder threshold.

Add a reorder label

  1. Put the quantity in B2. The sample quantity is 12.

  2. In F2, enter =IF(B2<15,"Order","OK") and press Return.

  3. Check the label and save the workbook.

The quantity and empty Reorder cell before entering the rule.

The quantity and empty Reorder cell before entering the rule.

Check both sides of the threshold

A quantity of 12 shows Order. Try 15 in a copy of the workbook. It should show OK because the condition uses less than 15. Confirm the formula still refers to the quantity cell.

The calculated Order label for the sample quantity.

The calculated Order label for the sample quantity.

Related guide open and save an XLSX workbook.

Steps checked in the Mac desktop editor with a practice file, including saving and reopening. Screenshots show the Ulet editor; the test used an isolated profile and file-picker fixtures.

Ulet

Paket aplikasi perkantoran lengkap untuk produktivitas sehari-hari.

Lihat fitur