This is somewhat contrived but will give you an idea of what’s possible with the IFS function. You might also consider using the SWITCH function, which works for exact matches. This account example is covered in Day 6 of my free Advanced Formulas 30 Day Challenge course. Note that this account example can also be solved with the VLOOKUP function using a TRUE value as the final argument. One way to do this is to use this IFS function in cell B2: Suppose you have a list of corporate bank balances and a table of interest rates, and you want to add the correct rate against the account balance so you can calculate the interest. You can also read about it in the Google documentation. If you click the link and open it in an Incognito window you’ll be able to see it. If you can’t access the template, it might be because of your organization’s Google Workspace settings. This is illustrated in the bank account example below.įeel free to make a copy: File > Make a copy… However, you can create a default fallback value by adding a penultimate argument TRUE (the logical test) and some value (the fallback value).The IFS function will then output an #N/A! error. There is no default value to display should all the conditions fail.It always starts with the leftmost argument as the first logical test. The function reads the test/value pairs from left to right.The conditions and values always come in a pair, so the IFS always has an even number of arugments.If condition 1 is FALSE, the IFS moves on to test condition 2, then 3, then 4 etc. These are optional pairs of logical tests and values.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |