How to Use the DROP Function in WPS on Windows

Last updated:July 17, 2026

Use DROP with 1 how-to topic, including entering and using the DROP function; choose a topic from the How-to Index and follow the entry point and steps below. This guide includes 1 free item and 0 membership-related items.

How-to Index

#TopicMembership
11. Enter and use the DROP functionFree

How-to Guide

1. Enter and use the DROP function

Entry point: Formulas tab → formula bar

  1. Open AirSheet and select the cell where you want to enter the formula.
  2. Type = in the formula bar or directly in the cell to start writing the formula.
  3. Type DROP( to view automatic syntax tips, parameter guidance, and examples.
  4. Enter the required parameters and press Enter to display the calculation result in the cell.

Success Criteria

  • UI state: The cell displays the calculation result of the DROP formula.
  • Next actions: You can continue editing parameters, copying the formula, or using the result in later calculations.
  • No side effects: Existing worksheet content remains open and unchanged.

Tips While Using

  • Common mistakes: If you do not type = first, the content may be treated as plain text.
  • Environment limits: The formula must be entered in an editable AirSheet cell.