(edited to fix the all-in-one formula here at the end. (edited to fix the all-in-one formula here at the to the help page for WEEKNUMBER, it starts the week on Mondays. =IF(AND(WEEKDAY([Planned Launch = 1, (WEEKNUMBER([Planned Launch + 23) > 52), (WEEKNUMBER([Planned Launch -29), IF(AND(WEEKDAY([Planned Launch 1, (WEEKNUMBER([Planned Launch + 22) > 52), (WEEKNUMBER([Planned Launch - 30), IF(WEEKDAY([Planned Launch = 1, (WEEKNUMBER([Planned Launch + 23), (WEEKNUMBER([Planned Launch + 22)))) Note: If you wanted to avoid using a helper column and get a little crazy, we'll just incorporate all the math into the formula itself: In English - If the week number is 31 or higher (which would mean week number + 22 is greater than 52) then subtract 30 from the week number, otherwise, just add 22 to the week number. Then, replace the WEEKNUMBER(, and we'll simplify the math to be more straightforward: =IF(WEEKDAY([Planned Launch = 1, (WEEKNUMBER([Planned Launch + 1), WEEKNUMBER([Planned Launch English, this says if the day of the week for the Planned Launch Date is Sunday, add 1 to the Week Number value for this date (this pushes Sunday week numbers into the following week's number ) if the week day is any other value, just use the week number value for the date. In the WeekNum column, use the following: You could probably accomplish this by using a helper column to alter the WEEKNUMBER results, and then use this week number in your formula. I assume you're trying to find the week number that is 22 weeks in the future.

It looks like, from your formula, that if the week number is 31 or higher, add 22 to the week number and then subtract 52 (note: why not just subtract 30?), otherwise, add 22 to the week number. I’d recommend memorizing it, or at least understand how it is derived).To the help page for WEEKNUMBER, it starts the week on Mondays. Average: Total/# of numbers (This is the only non-geometry formula.Formulas not on the SAT’s math cheat sheet The relationship between the two equal sides and the hypotenuse is that the hypotenuse will always be √2 times greater. Just make sure you know how the sides are connected.įor instance, sometimes you can have a √2 as one of the sides. But at the end of the day, if you don’t know memorize the formula, you can just use the cheat sheet. 45:45:90Īs a tutor, I always want to make sure my students know this well. Just make sure you know what everything stands for when you refer to the diagram. 30:60:90 triangleĭon’t feel you have to know this cold, though it will make things faster. And be fluent and being able to find the missing sides. So it’s great to see it as part of the cheat sheet at the beginning of each section.

You probably won’t see a problem relating to a cylinder.

For a cube, things are much easier: volume is s^3, in which s = the side surface area is 6s^2. One thing you don’t get is the surface area of a box. Volume of a boxĭon’t memorize this-just refer back to the page if necessary. Don’t waste time flipping the pages back and forth. Perimeter, which is not part of the SAT cheat sheet, is found by adding the length and width and multiplying by 2. Quadratics: quadratic formula (roots), vertex form, vertex, y y y-intercept, discriminant Circles: arc length, area of a sector, equation of a circle, center. To find the area of a rectangle/square multiply length x width (they are the same in a square).

Sat formula sheet