Use RANDBETWEEN through 4 topics, including entering the formula, filling in parameters, confirming the result, and fixing errors or recalculating; choose a topic from the index and follow the steps.

How-to Index

#	Topic	Membership
1	1. Enter the RANDBETWEEN function	Free
2	2. Fill in parameters from the prompt	Free
3	3. Confirm and review the result	Free
4	4. Fix errors or recalculate manually	Free

How-to Guide

1. Enter the RANDBETWEEN function

Entry point: Formulas tab → formula bar

Open AirSheet and select the cell where you want to enter the formula.
Type = in the formula bar or directly in the cell.
Continue typing RANDBETWEEN( and review the syntax prompt.

Success Criteria

UI state: The current cell enters formula input mode and shows the function name.
Next actions: You can continue entering parameters and complete the formula.

Tips While Using

Common mistakes: If you do not type = first, the content may be treated as plain text.

2. Fill in parameters from the prompt

Entry point: Formulas tab → formula bar

After RANDBETWEEN(, enter the starting value.
Enter the separator, then enter the ending value.
Use the syntax prompt to check that the parameter count and format are correct.

Success Criteria

UI state: The formula includes complete lower and upper bound parameters.
Next actions: You can press Enter to calculate the result.

Tips While Using

Common mistakes: Missing a closing parenthesis or separator can cause a formula error.

3. Confirm and review the result

Entry point: Formulas tab → formula bar

After finishing the formula, press Enter.
Review the random integer returned in the cell.
If needed, copy the formula to other cells.

Success Criteria

UI state: The cell shows an integer within the specified range.
Next actions: You can continue editing, filling, or referencing the result.

Tips While Using

Common mistakes: Treating the result as fixed and overlooking that recalculation can change it.

4. Fix errors or recalculate manually

Entry point: Formulas tab → result cell

If the formula shows an error, check the parentheses, parameter types, and parameter count.
Check whether referenced cells contain numbers stored as text or whether there is a circular reference.
Press F9 to trigger recalculation when you need a new result.

Success Criteria

UI state: The error is cleared, or the cell returns a new valid result.
Next actions: You can continue with spreadsheet calculation and analysis.

Tips While Using

Common mistakes: Referencing text values that cannot be used in calculation.
Environment limits: Manual recalculation requires the current sheet to remain editable.