Learn How To Use the IF Function In Numbers

The IF function is how to test values in spreadsheets. You can use it to simply test a value and show different results. But the key to making complex spreadsheets to learning more about the IF function. You can pass through values when a condition is met, combine conditions with AND and OR functions, and nest IF functions for more than two possible results.

Download the file: 2041NumbersIfDemos.zip

Comments: 6 Responses to “Learn How To Use the IF Function In Numbers”

    Dan Brady
    5 years ago

    Very well explained. Thank you

    Steve Housley
    5 years ago

    Gary, you make it look so simple. Now if I could only locate the file. " I'll make this Numbers file available on the website for you to download."

    5 years ago

    Steve: Sorry about that. I added a link to the download above the Comments section.

    Tom Gifford
    5 years ago

    Thanks Gary - you really make this material easy to understand. Now, however, you got me looking forward to MATCH and LOOKUP in an upcoming video.

    John S
    4 years ago

    The best and most concise explanation I’ve ever seen Typical Gary😊

Comments Closed.