Nested IF - Used when you have more than 2 possible criteria to solve a problem. Must be written by you, the function box cannot help you., V Look Up - Searches columns to find information matching the criteria., H Look Up - Searches rows to find informations matching the criteria., Count IF - Performs a count, but only if a cell meets a certain criteria., Sum IF - Adds things together, but only if a cell meets certain criteria., Round Up - Will round an answer upwards to the nearest number/pound., Round Down - Rounds a number downwards to the nearest number/pound., IF - Used to work out if a cell meets a criteria. There will only ever be 2 possible criteria here before you need to use a Nested If.,

H Admin Spreadsheet Formula

door
Afdrukken
Embedden

Scorebord

Visuele stijl

Opties

Template wisselen

Automatisch opgeslagen activiteit "" herstellen?