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

This note was uploaded on 07/06/2011 for the course CGS 1055 taught by Professor Magnusson during the Spring '08 term at University of Florida.

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