A lender screens applications in a sheet. Each task asks for one check in column F or beyond; write it in the first row and fill it down when the task says so. Pick the function that fits: one condition (IF), several that must all hold (AND), any of several (OR), exactly one (XOR), bands (IFS), exact codes (SWITCH), or what a cell holds (the IS functions).
Watch the boundaries: "at least 700" includes 700.