jaramillo3.9 - After Tax/Fee Income: =B23-SUM(B18:B20)...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Juan Jaramillo Vishak Sivakamur Period #5 Tutorial #3 FORMULAS TO CALCULATE 6 IF STATEMENTS – Copies from  Excel’s formula bar. Minimum:  =IF(H43=B36,"JAN",IF(H43=C36,"FEB",IF(H43=D36,"MAR",IF(H43=E 36,"APR",IF(H43=F36,"MAY",IF(H43=G36,"JUN")))))) Maximum:  =IF(H44=B36,"JAN",IF(H44=C36,"FEB",IF(H44=D36,"MAR",IF(H44=E 36,"APR",IF(H44=F36,"MAY",IF(H44=G36,"JUN")))))) ANOTHER FORMULA TO CALCULATE: After Tax/Fee Income: =B23-(B18+B19+B20) Balance: =B24-B36 ORIGINAL FORMULA CALCULATED:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: After Tax/Fee Income: =B23-SUM(B18:B20) Balance: =B24-SUM(B27:B35) Formula from I39: =IF(D39>1980,IF(B24>1590,YES,IF(D36<1550,YES,NO))) Formula from I40: 3/30/2008 6:15 PM jaramillo3.6.docx Juan Jaramillo Vishak Sivakamur Period #5 Tutorial #3 =IF(AND(0,1,1),IF(B10,True,False),IF(OR(IF(B11,1,0),True,False), This Tutorial is Amazing!,This Tutorial is Remarkable!)) 3/30/2008 6:15 PM jaramillo3.6.docx...
View Full Document

Page1 / 2

jaramillo3.9 - After Tax/Fee Income: =B23-SUM(B18:B20)...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online