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: 5 Responses to “Learn How To Use the IF Function In Numbers”

    Dan Brady
    2 weeks ago

    Very well explained. Thank you

    Steve Housley
    2 weeks 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.”

    2 weeks ago

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

    Tom Gifford
    1 week 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.

Leave a New Comment Related to "Learn How To Use the IF Function In Numbers"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)