To enter a formula:
Left-click on the cell that you wish to enter a formula into. A heavy border should appear around the cell.
Type an equal sign (=). This tells EasySpreadsheet that you are entering a formula.
Enter your formula. Examples are given below:
Function |
Operator |
Example |
|
Formula |
Value (Result) | ||
Addition |
+ |
=5+5 |
10 |
Subtraction |
- |
=6-4 |
2 |
Multiplication |
* |
=3*2 |
6 |
Division |
/ |
=9/3 |
3 |
Exponentiation |
^ |
=2^3 |
8 |
Percent |
% |
=75% |
0.75 |
Greater Than |
> |
=5>3 |
TRUE |
Less Than |
< |
=5<3 |
FALSE |
Equal To |
= |
=5=3 |
FALSE |
Greater Than or Equal To |
>= |
=5>=3 |
TRUE |
Less Than or Equal To |
<= |
=5<=3 |
FALSE |
Not Equal To |
<> |
=5<>3 |
TRUE |
Concatenation |
& |
=2&3 |
23 |
Brackets |
( ) |
=(2+1)*6 |
18 |
Scientific Notation |
E |
=1E2 |
100 |
If you left-click once on the cell at any time, the formula will appear in the text box above your spreadsheet. This text box is called the formula bar.
You can edit your formula by typing in the formula bar. Press Enter when you are finished editing.
Formulas with Cell References
Formula |
Description |
=A1+A2 |
Adds the values found in cells A1 and A2. |
=C3-A1 |
Subtracts the value found in A1 from the value found in C3. |
=C1*C5 |
Multiplies the value found in C1 by the value in C5. |
=A1>A2 |
Determines whether or not the value in A1 is greater than the value in A2. |
=A1=A2 |
Determines whether or not the value in A1 is the same as the value in A2. |
=C2% |
Produces a percent value based on the value in C2. |
=C1&C3 |
Produces a string made up of the values (or labels) found in C1 and C3. |
=(A1+A2)/C1 |
Adds the values in A1 and A2, then divides this result by the value in C1. |
Enter test values in cells C1 and C2. For example, put the value 10 in C1, and the value 20 in C2.
Click on cell C3.
Type in the formula: =(C1+C2)*5
Press the Enter key. The number 150 will automatically appear in cell C3. This makes sense, as (10+20)*5 is 150.
If you left-click once on cell C3, the formula (i.e., =(C1+C2)*5 ) will become visible in the formula bar above the spreadsheet.
Showing and Hiding Formula Bar
If the formula bar (the text box just above the spreadsheet) is not visible, go to the View menu, and ensure that Formula Bar is checked off. This will show the formula bar.
To hide the formula bar, un-check Formula Bar under the View menu.