The Subtract Formula In Google Sheets. The syntax is if test then_true otherwise_value. To nest multiple IF statements together into a single formula simple type IFfirst_test value_if_true IFsecond_test value_if_true value_if_false.
While this only shows a single nested IF statement you can nest as many IF statements together as you require.
If you want the formula for the entire row this will probably be the first or second row in a column Type the equal sign. While this only shows a single nested IF statement you can nest as many IF statements together as you require. A suggestion box appears to help. How to Enter a SUM Function in Google Sheets.