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

만든이
인쇄
퍼가기

순위표

비주얼 스타일

옵션

템플릿 전환하기

자동 저장된 게임을 복구할까요?