This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Excel Out of the Ordinary Formulas Formatting Drawing & Graphics Special Features Formulas 1. IF and Nested IF statements Provide branching in calculations. 25 Elephant The number is 25! The number is 25 and the animal is Elephant. 2. Join first and last names Join a list of first names in one column with a list of last names in another column using a formula. First Last Formula 1 Formula 2 John Smith John Smith Smith, John Kaspar Johnson Kaspar Johnson Johnson, Kaspar Emma Bovary Emma Bovary Bovary, Emma 3. Join a date with text To concatenate two values (as above) use the concatenation (&) operator. To connect a date or time value stored in a cell with a text string, use the TEXT function. Date: 9/12/2000 Text: Date: Wrong: Date: 36781 (uses concatenation only) Right: Date: 09-12-00 (uses concatenation plus the TEXT function) 4. Create a total based on a condition Use the SUMIF function to create a total value for a range based on a value in another range. For example, for every cell in the range below that contains the value "NorthWind", the example formula calculates the total for the corresponding cells in the range next to it.the example formula calculates the total for the corresponding cells in the range next to it....
View Full Document
This note was uploaded on 12/20/2011 for the course BUS 101 taught by Professor Ecklund during the Spring '01 term at Duke.
- Spring '01