0

inconsistent forumula

Good morning,

Could someone help me out with the following?

I have a report, in which I have embedded an IF..THEN formula:

=IF($G14=$G13;"combinatie";$AQ14)

Jet reports expands al rows perfectly and above mentioned formula modifies smoothly in the newly added rows…with one exception
When my formula hits a case in which G14 equals G13, the cell gives the word 'combinatie'.
When the next row after that is a case in which G15 isn't G14, the formula suddenly becomes inconsistent. it then becomes

=IF($G15=$G13;"combinatie";$AQ15)
So it sort of neglects the version in which the result is TRUE and counts back to the last case in which it was UNTRUE

I have the idea this should be easily fixed, I'm just too blind to see…. :shock:

Thanks in advance!

Marc

2 comments

Please sign in to leave a comment.