If&amp;LogicDemo

# If&amp;amp;LogicDemo - Max 800 The smallest number is 2....

This preview shows pages 1–3. Sign up to view the full content.

IF and LOGIC DEMO WORKSHEET Excel's IF function and its logical functions (AND, OR, MAX, and MIN) can be extremely useful when constructing spreadsheet models. This workbook shows some simple examples.

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

View Full Document
IF, AND, and OR Functions The Test Variables 25 elephant IF statement The number is 25. Nested IF statements The number is 25 and the animal is Elephant. The AND and OR Functions TRUE TRUE
MAX and MIN Functions The Test Values 100 The largest number is 800.
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Max 800 The smallest number is 2. Min 2 A widget retailer orders a shipment of widgets at a special price. If demand exceeds their order, the retailer must meet demand with regular price items. Inputs Calculations Using Excel's MAX and MIN Functions Quantity 600 Special price widgets sold 350 Special price widgets unsold 250 Demand 350 Regular price widgets sold Quantity ordered at the special price...
View Full Document

## If&amp;amp;LogicDemo - Max 800 The smallest number is 2....

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

View Full Document
Ask a homework question - tutors are online