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

由
打印
嵌入

排行榜

视觉风格

选项

切换模板

恢复自动保存：？