You can write formulas exactly as you do using the keyboard in Excel, but you can enter them much more easily using MoboCalc's innovative formula layout features.
Important: All formula entries must begin with an equal sign ("="). Otherwise, they will be interpreted as text.
MoboCalc lets you write formulas in a natural layout rather than as a string of text characters. This not only makes your formulas more readable but also reduces the need for parentheses.
Here are some of the techniques you can use.
Division |
You can replace Excel division symbols (/) with true division lines. |
|
|
Multiplication |
You can use either a * symbol or a single dot to multiply two values. |
|
|
Exponents |
You can write real exponents instead of using the ^ symbol. |
|
|
Comparisons |
You can use these symbols instead of <>, >=, and <=. |
|
|
Square roots |
You can use square root signs in place of the SQRT function. |
|
|
Other functions |
You can also use symbols in place of many other functions. |
|
|
SUM |
|
|
|
PRODUCT |
|
|
|
SUMPRODUCT |
|
|
|
EXP |
|
|
|
PI |
|
|
|
FACT |
|
|
|
ABS |
|
|
|
NOT |
|
|
|
You can use any of these shortcuts when writing formulas, whether or not you choose to display them by default.
In addition, you can write logical expressions in a more natural order. For example, instead of entering:
=AND(OR(H12>=100,H14>5),G13<>0)
you can write
In general, formulas should be printed. Cursive script can only be used for text strings enclosed by quotation marks.
Cell addresses and function names can be written in either upper or lower case. However, their text display is based on the preferences you choose for displaying formulas in the Options dialog. See Controlling formula display for further information.
Range names can also be entered in either upper or lower case, but their display is controlled by their original definition.
Erasing all or part of your formula
Before you check or enter your formula, you can use the eraser tool or the eraser tip of your pen to remove all or part of your entry. You can quickly clear your entry and start over by tapping the Cancel button.
You can add to the end of a formula after erasing all or part of it. For example:
Write |
|
Erase "c7" |
|
Replace it with "e9" |
|
Tap Check to verify your revised formula |
|
Editing your formula
If you check your formula before sending it to Excel and notice any errors, you can correct them using any of the techniques described in Editing formulas and Editing cell contents.