iDoceo - Gradebook and planner for Mac, iPad and iPhone
  • Home
  • Apps
    • News
    • iDoceo - Teacher's gradebook
    • Grade Scanner
    • Classroom Teammates
    • Classroom roulette
    • iDoceo Badge Maker
    • iDoceo Tools Full Pack
  • Manual
    • How to
      • Assign photos
      • Change a column's position
      • Enable full screen
      • Add annotations to a cell
      • Change a column's editor
      • Add a new tab/page
      • Backup&Restore
      • Import XLS or CSV files
      • Create student groups
      • Calculations - Examples&Instructions
    • QuickStart
    • Instructions manual
    • The diary
    • The student report
    • Privacy policy
    • Main gestures
  • Forum&FAQ
    • Index
    • Recent posts
    • FAQ - Frequently asked questions
  • Search
    • Search articles
    • Search in forum
    • All articles
  • Contact us
iDoceo — Avenir Next Bold
Features
Apps
iDoceoGrade ScannerClassroom TeammatesClassroom RouletteBadge MakeriDoceo Tools Full Pack
Manual
Manual overview
How to
How toAssign photosChange a column's positionEnable full screenAdd annotations to a cellChange a column's editorAdd a new tab/pageBackup&RestoreImport XLS or CSV filesCreate student groupsCalculations - Examples&Instructions
QuickStartInstructions manualThe diaryThe student reportPrivacy policyMain gestures
Forum & community
ForumRecent topicsSearch
SearchContact us
Menu
Features
Manual
Manual overview
How to
How toAssign photosChange a column's positionEnable full screenAdd annotations to a cellChange a column's editorAdd a new tab/pageBackup&RestoreImport XLS or CSV filesCreate student groupsCalculations - Examples&Instructions
QuickStartInstructions manualThe diaryThe student reportPrivacy policyMain gestures
Forum & community
ForumRecent topicsSearch
Help centre & FAQSearchContact usiDoceo & apps
OverviewGradebookPlanningClassroomResourcesConnectYour data
← All manual topics

Calculations

A+

Calculations

These are all the HowTos related to calculations.  This list is updated quite often, but if you don't find what you're looking for, drop us a line at the forum.

 

Filters
Title
ICONRESULT: Show an icon in a formula
Attendance formulas: Columns, icons and delay
SELF(): Use a folder’s own columns
NUMCOL: Count non-empty cells
COLORCELL: Colour a formula result
STUDENTICON: Choose between two averages
COUNTBLANK: Count empty cells
AVERAGEIF: Average with a condition
TEXT: Show a message with a condition
FOLDER: Use a folder in a formula
COUNTIF: How many tests has each student passed?
Using Tags in your Gradebook
Icon counter
Formula Functions: Averages
Formulas: How to use its functions
  • 1
  • 2
  • 3
Page 1 of 3

Recently updated articles

  • What’s new in iDoceo 9.6.0
  • ICONRESULT: Show an icon in a formula
  • Attendance formulas: Columns, icons and delay
  • SELF(): Use a folder’s own columns
  • NUMCOL: Count non-empty cells
  • COLORCELL: Colour a formula result
  • STUDENTICON: Choose between two averages
  • COUNTBLANK: Count empty cells
  • Privacy policy
© 2011-2026 iDoceo Studios Ltd.
iDoceo - Gradebook and planner for Mac, iPad and iPhone
  • Home
  • Apps
    • News
    • iDoceo - Teacher's gradebook
    • Grade Scanner
    • Classroom Teammates
    • Classroom roulette
    • iDoceo Badge Maker
    • iDoceo Tools Full Pack
  • Manual
    • How to
      • Assign photos
      • Change a column's position
      • Enable full screen
      • Add annotations to a cell
      • Change a column's editor
      • Add a new tab/page
      • Backup&Restore
      • Import XLS or CSV files
      • Create student groups
      • Calculations - Examples&Instructions
    • QuickStart
    • Instructions manual
    • The diary
    • The student report
    • Privacy policy
    • Main gestures
  • Forum&FAQ
    • Index
    • Recent posts
    • FAQ - Frequently asked questions
  • Search
    • Search articles
    • Search in forum
    • All articles
  • Contact us