If&LogicDemo

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

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

View Full Document Right Arrow Icon
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.
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
MAX and MIN Functions The Test Values 100 The largest number is 800.
Background image of page 3
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

Page1 / 3

If&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 Right Arrow Icon
Ask a homework question - tutors are online