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.[6]
=IF( AND( Line26>Line28, Line26<=I6), Line26, "")
Write a formula to calculate any of the cells in Line31.[4]
=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
 PAUL

Click to edit the document details