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
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😊