1 / 7

Conditional Formulas using the IF Function

IF Functions. Use flowcharts to ensure proper construction IF (hours worked>40, calculate overtime, overtime is 0). Hours worked > 40. Overtime = 0. Calculate Overtime. . . . . True. False. Nested IF Functions. IF functions evaluates one condition and two alternatives Use AND, OR, and NOT to tes

saad
Download Presentation

Conditional Formulas using the IF Function

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

    1. Conditional Formulas using the IF Function IF (logical_test, value_if_true, value_if_false) Can only compare two expressions Comparison operators Less than < Greater than > Less than or equal to <= Greater than or equal to >= Equal to = Not equal to <>

    2. IF Functions Use flowcharts to ensure proper construction IF (hours worked>40, calculate overtime, overtime is 0)

More Related