How to use formulas in mobile Excel: input, multiplication and drop-down filling

Key points of this article

The formula should start with an equal sign, for example, enter =B2*C2 in the cell, and press Enter to display the calculation result.
Multiplication formulas use cell addresses to reference data. If the data is changed, the results will be automatically updated without having to recalculate by hand.
When filling downward, drag the fill handle in the lower right corner, or copy the formula cell and paste it into the lower area, and the reference will automatically change with the line.
If you want the cells to retain only numbers and no longer change with the data, use the Keep only numerical value option in Paste Special instead of deleting the formula directly.
OmniDoc does not have a separate mobile table editing function, and the input and filling of table formulas still need to be completed in the mobile Excel application or on the computer.

When you open a quotation, budget sheet or inventory sheet on your mobile phone, you often need to calculate the unit price times the quantity, the total amount, or the percentage of a column of data. If you type each line manually on the calculator, it will be slow and easy to miss lines. Excel's formulas can solve this problem, but the mobile phone screen is small, and the input box and filling gestures are not exactly the same as the computer version. Many people will get stuck on "how to enter the formula" and "how to drag it to the following dozens of lines" for the first time.

This article is for people who need to work with forms on their mobile phones. You'll learn three things: how to enter formulas, how to use multiplication formulas to calculate a column of data, and how to fill formulas down to other rows. Finally, it will be explained what to do if you want to turn the formula into a fixed number and no longer change with the data.

Let’s talk about the conclusion first: the mobile version of Excel can use formula calculations normally, and the core operations are the same as the computer version, but the entrance and gestures must adapt to the screen. OmniDoc currently does not have a separate mobile table editing function. The following steps are subject to the Excel application on the mobile phone.

How to use formulas in mobile Excel? One sentence conclusion

First enter the equal sign in the target cell, then use the cell address combination operation and press Enter to get the result; to fill in the rows below, use the fill handle to copy downwards. How you do this depends on your data:

your situation	Recommended practices	reason
The unit price and quantity are on the same line and only count as one line.	Direct input =B2*C2	Simple, the result changes with B2 and C2
The same calculation takes dozens of lines	After writing the first line of formula, fill it down	References will automatically change on a line-by-line basis, no need to enter them line by line.
Dragging the fill handle on the phone screen is very laborious	Copy the formula cell, then select the area below and paste it	Avoid insufficient finger operation accuracy
You want to hand over the results to others and do not want the other party to change the data and affect the results.	Keep values with paste special	Remove the formula and leave only the calculation results
I just want to see the formula content, not the results.	Check it on your computer first, or look for the display method in the application settings.	The display options on the mobile phone vary depending on the version, so there is no need to force it.

Before you start: Confirm these points first

Before you start, take a look at the table structure, because whether the formula can be calculated correctly depends largely on the data itself.

Confirm numbers are in number format: If the unit price or quantity looks like a number, but is aligned to the left, it's probably text. When literal numbers are multiplied, the result may be 0 or an error may be reported. You can try entering =B2*2 in the cell to see if the result is normal.
Confirm table header and data location: The address in the formula must point to the actual data. For example, the first row is the header and the data starts from the second row, then the first formula should be written in D2, not D1.
Confirm mobile phone input method and symbols: Some input methods will input equal signs and asterisks into full-width characters. Half-width symbols must be used in the formula, and the multiplication sign must be *, not ×.
Confirm whether the formula needs to be retained: If the unit price or quantity will be modified later, keep the formula; if you only submit a final result, consider converting it to a numerical value, otherwise the result will change when others change the source data.
Confirm whether you want to modify the form on your mobile phone: Mobile phones are suitable for viewing and small modifications, while large-scale filling and formatting are more suitable for completion on a computer.

Steps to enter multiplication formulas in mobile Excel and fill them down

Let's take a table as an example: Column B is the unit price, column C is the quantity, and the amount needs to be calculated in column D. This table has 12 rows of data and is suitable as an exercise.

Open the table and select the target cell: Open the file in Excel on your mobile phone and click on cell D2, which is the amount position of the first piece of data.
Input starting with an equal sign: Enter = first in the cell input box, indicating that the next step is a formula instead of ordinary text.
Reference unit price cell: Enter B2, which is the unit price of row 2. You can also click B2 to have the app fill in the address automatically to reduce the chance of making a mistake.
Enter the multiplication sign and quantity address: Enter , then enter C2. The complete formula is =B2C2.
Confirm result: Click the check mark or press Enter, D2 should display the result of "unit price times quantity". Check it with an easy number (such as 10 times 3 to get 30).
Select formula cell: Click D2 again, a small square will appear in the lower right corner of the cell, which is the fill handle.
Fill Down: Use your finger to drag the fill handle all the way to line 13. After releasing, D3 will automatically become =B3C3, D4 will become =B4C4, and so on.
Alternative: Copy and Paste: If dragging is unstable, you can copy D2 first, then select D3 to D13 and perform paste. References also vary by line, with consistent results.

Once completed, spot check three or four lines to confirm that each line refers to the unit price and quantity of the same line.

Check each item after completion

After filling in the formula, do not send it directly to others. Do a round of checking first. The following items are prone to problems.

Check items	How to see	What to do if there is a problem
Do the results have numbers?	Check whether there is 0, blank or error message in column D	Check whether the unit price or quantity of the corresponding line is text, change it to a number and recalculate it.
Whether the reference changes with the line	Click on cells such as D3 and D10 to see if the row number in the formula is consistent with the current row.	If they all point to line 2, it means the address is locked. Go back to the first line and re-enter the formula before filling it in.
Is the symbol correct?	Check whether the multiplication sign in the formula is * and whether the equal sign is half-width	Delete the full-width characters and re-enter
Are there any missing rows?	Check the last row of the data area to see if column D extends to the bottom	Select the last formula and fill it down to the end
Is the total consistent with the hand calculation?	Select a row at random and use the calculator to calculate it once	In case of inconsistency, check whether the quoted unit price and quantity come from the same line

If the result is abnormal, check the data format first, and then check the formula address. Most of the problems lie in these two places. Note that machine calculations will not automatically check the business meaning for you, such as whether the units are unified and whether the tax rate is included in the unit price. You need to confirm these yourself.

How to turn off the formula: keep the result and remove the formula

When many people say "turn off formulas", they actually want the cells to retain only the calculation results and no longer change with the source data. Do not delete the formula directly at this time, because the numbers will disappear after deletion. The correct way is to convert the formula into a numerical value:

Select the range containing the formula, such as D2 to D13.
Copy these cells.
Open the paste option at the target location and select the item that only retains the numerical value.
After pasting, click on the cell to check. Only numbers should be displayed in the edit bar, no longer starting with an equal sign.

After conversion, these numbers are static values, and modifications to column B or C will not affect them. It is recommended to save another copy before conversion, because the formula cannot be automatically restored after numericization.

If you just want to view the formula content in the table rather than the results, the display method of the mobile version varies depending on the app version. This requirement is more convenient to view on a computer, and the same file can be opened in Excel on the computer for inspection.

Can the mobile version be calculated using formulas? What OmniDoc can do for you

The mobile version of Excel can enter and calculate common formulas normally, including multiplication, addition, summation, and cell references. For daily price calculations, progress statistics, and simple reports, mobile phones can completely complete it. For complex multi-table linkages, large amounts of data pivots and advanced functions, it is still recommended to return to the computer for processing.

What OmniDoc has to do with this needs to be made clear. It can be opened and used in the mobile browser on the omnidoc.top web version, but currently it provides document translation and supports the translation of Excel files. The input, filling and numerical conversion of table formulas still have to be completed in the Excel application on the mobile phone. If your need is to translate the table content into other languages while retaining the table structure, you can use OmniDoc; if you need to change the formulas, you must use the spreadsheet software itself.

The desktop client OmniDoc includes the UniCell spreadsheet function, which is suitable for situations where you need to process forms on your computer. The download address is download.omnidoc.top.

❓ Frequently Asked Questions (FAQ)

1. After entering a formula in mobile Excel, text is displayed but no calculation is performed. What should I do?

Most likely it's because there is no equal sign in front of the formula, or the cell format is set to text. First check if it starts with =, then change the cell format to regular or numeric, and then re-enter the formula.

2. The multiplication formula calculated by the mobile phone is wrong or 0. What is the reason?

The common reason is that the numbers involved in the calculation appear to be numbers, but are actually text, or they may have spaces or full-width symbols mixed in. Use a simple formula to test, such as =B2*2. If it is not correct, first convert the source data into numbers.

3. When filling down, why does each row refer to the same cell?

This is usually because the address is fixed, or a value is copied instead of a formula. Check the first line of formula to make sure it refers to a relative address such as B2, rather than an absolute reference with a dollar sign in front of the column letter and row number, and then fill it in again.

4. Can the mobile version of Excel view all formulas like the computer version?

The display options on the mobile phone vary depending on the version, and you may not be able to see all the formulas at once. If you need to comprehensively check the formula, it is recommended to open the same file on your computer and check column by column.

5. What is the difference between free online spreadsheet tools and mobile Excel?

When choosing an online spreadsheet or free tool, you can focus on three things: file size limits, whether a watermark will be added to the exported file, whether formulas and formatting will be preserved, and where your data will be stored. For forms involving sensitive data, you must first confirm the privacy statement of the service provider.

📝 Summary

The formula usage in the mobile version of Excel is not complicated: start with an equal sign, use the cell address to multiply, and then use the fill handle to copy downwards. When you need to fix the results, use Paste Special to retain the values. After finishing, you can spot-check the references and data format, and you can basically avoid most errors. Mobile phones are suitable for processing small tables, but it is still recommended to complete complex formula editing and table layout on a computer.

Open OmniDoc and work with your spreadsheet file