C10i10 line29 federaltaxc7i7 line33 federaltaxc11i11

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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.

Ask a homework question - tutors are online