Help with multiple condition IF formula
Hi, I am trying to create a formula field for a multiple leveled IF question so I can automatically set the status of an instrument in regards to when it should be returned. The bellow Table is a b...
Forum Discussion
My advice is the following.
The IF statement will process the tests in the sequence they are listed, and it will return the first one that is true. So, for any which are not calculating correctly, you need to just deal with them systematically one by one. Choose the first example that you want to fix. Take note of the values in the fields on he record that is incorrect. Manually do each test and see what the formula is calculating to. You may find that the sequence of the tests need to be changed.
For me to help you with an example of one that is incorrect, I will need to know what is in each field which is being tested, as I cannot see your data.
There is no shortcut to solving the issues one by one. Start with the first one that is not correct, and get that 1 working, and then move on to the next one.
The IF statement will process the tests in the sequence they are listed, and it will return the first one that is true. So, for any which are not calculating correctly, you need to just deal with them systematically one by one. Choose the first example that you want to fix. Take note of the values in the fields on he record that is incorrect. Manually do each test and see what the formula is calculating to. You may find that the sequence of the tests need to be changed.
For me to help you with an example of one that is incorrect, I will need to know what is in each field which is being tested, as I cannot see your data.
There is no shortcut to solving the issues one by one. Start with the first one that is not correct, and get that 1 working, and then move on to the next one.