Jaramillo3.6 - =IF(H44=B36"JAN",IF(H44=C36"FEB",IF(H44=D36"MAR",IF(H44=E

Info iconThis preview shows page 1. 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: 
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: =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 ORIGINAL FORMULA CALCULATED 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.

Ask a homework question - tutors are online