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.
Check out Learn How To Use the IF Function In Numbers at YouTube for closed captioning and more options.
Download the file: 2041NumbersIfDemos.zip
Very well explained. Thank you
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."
Steve: Sorry about that. I added a link to the download above the Comments section.
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.
Tom: See https://macmost.com/using-index-and-match-functions-to-look-up-values-in-numbers.html and https://macmost.com/using-multiple-tables-and-lookup-in-numbers.html
The best and most concise explanation I’ve ever seen Typical Gary😊