Positive variances
Oh boy, we're getting close to your crowning achievement.
Let's level up this report by showing each line that increased over 10% and $10,000.
Recall that the AND function accepts two or more arguments, returning TRUE if they are all TRUE and FALSE if any of the arguments are FALSE. The function uses the following format:
AND(first argument, second argument, ...)
Deze oefening maakt deel uit van de cursus
Voorwaardelijke opmaak in Google Spreadsheets
Oefeninstructies
- Add a conditional formatting rule using a custom formula that highlights each row, column
AthroughF, that exceeds $10,000 (10000) and 10% (0.10) variance.- For each criteria in the
ANDfunction, fix the column with a$(e.g.$F2) but do not fix the row (e.g.$F$2). - For the purposes of this exercise, make sure to pass the arguments to the
ANDfunction in the order in which the columns appear (i.e.EbeforeF).
- For each criteria in the
- Use the Default green background in your custom formula to show the positive variances.
Interactieve oefening met praktijkervaring
Zet theorie om in actie met een van onze interactieve oefeningen
Begin oefening