This preview shows page 1. Sign up to view the full content.
Unformatted text preview: :$I$10 Line29 =FederalTax!$C$7:$I$7 Line33 =FederalTax!$C$11:$I$11 In most cases, the instructions for calculating the cells in the line are given to the left.
NOTE the Income level conditions that apply for each column.
Also note that cells should appear empty when not needed.
Write a formula to calculate Line27 for the second highest Income level.
=IF( AND( Line26>Line28, Line26<=I6), Line26, "")
Write a formula to calculate any of the cells in Line31.
=IF( ISNUMBER( Line27), Line29*Line30, "") +1 for repeating the rest of the IF again
Other tests w...
View Full Document
This note was uploaded on 04/06/2013 for the course CSE CSE 1520 taught by Professor Paul during the Fall '09 term at York University.
- Fall '09