BioloMICS logo
×
BioloMICS menu
Search
 
   
   
   
 

Formulas pane

Formulas pane
 
For detailed information about each formula, see Formulas.
 
Note that not all formulas in the formula section are usable in the spreadsheet processor.
 
1

AutoSum

1. AutoSum
AutoSum is used to display the results of simple calculations, such as Average or Maximum Value, after the selected the selected cells.
 
2

Financial Formulas

2. Financial FormulasBrowse and select from a list of financial functions.
 
3

Logical Formulas

3. Logical Formulas
Browse and select from a list of logical functions.
 
4

Text Formulas

4. Text Formulas
Browse and select from a list of text functions.
 
5

Date & Time Formulas

5. Date & Time Formulas
Browse and select from a list of date & time functions.
 
6

Lookup & Reference Formulas

6. Lookup & Reference Formulas
Browse and select from a list of lookup & reference functions.
 
7

Math & Trigonometry Formulas

7. Math & Trigonometry Formulas
Browse and select from a list of math & trigonometry functions.
 
8

More Formulas

8. More Formulas
Browse and select from a list of statistical, engineering, cube, informational and compatibility functions.
 
9

Show Formulas

9. Show Formulas
Display the formula in each cell instead of the resulting value. Can also be done by pressing Ctrl + `
 
10

Name Manager

10. Name Manager
Create, edit, delete and find all the names used in the workbook.
 
Names can be used in formulas as substitutes for cell references.
 
Can also be opened by pressing Ctrl + F3.
 
11

Define Name

11. Define Name
Name cells so that you can refer to them in formulas by that name.
 
Names can be used in formulas to make them easier to understand.
 
12

Use in Formula

12. Use in Formula
Choose a name used in this workbook and insert it into the current formula.
 
13

Create from Selection

13. Create from Selection
Automatically generate names from the selected cells.
 
Many people choose to use the text in the top row or leftmost column of a selection.
 
Can also be done by pressing Ctrl + Shift + F3.
 
14

Calculation Options

14. Calculation Options
Specify when formulas are calculated.
 
By default, any time you change a value that affects other values, the new values are calculated immediately.
 
15

Calculate Now

15. Calculate Now
Calculate the entire workbook now.
 
This is only necessary if automatic calculation has been turned off.
 
Can also be done by pressing F9.
 
16

Calculate Sheet

16. Calculate Sheet
Calculate the current sheet now.
 
This is only necessary if automatic calculation has been turned off.
 
Can also be done by pressing Shift + F9.
 
(c) BioAware, 2024