Joined: 09 Oct 2015
Online Status: Offline
Posts: 3
Topic: Formula Editor Posted: 22 Feb 2016 at 12:26pm
Good Afternoon
I have a formula with 8 if/then/else statements...if I move the
6th if/then/else statement to the top in the formula editor, my results change...if I then move the 8th one to the top, the results change...etc....
Do you have any idea why it does this and how can I fix it?
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 23 Feb 2016 at 3:40am
two things to keep in mind.
first, if you have null values you need to address them first or in each if-then or it will stop evaluating when it hits that null in the row or use the option to 'use default values for nulls'.
second, your if-then runs in sequence, the first if-then condition the row meets ends the execution on that row and returns that "then" value. By changing the order it can change the result because a row might meet more than one if-then but will only return the first in the sequence.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum