Forum Discussion
Mederic
Post Patron
Post PatronHandling Null Values
Hello, The article in the following link presents 2 methods for handling null values. However, the 2nd method does not seem to give the same result as the 1st method. How can we correct this probl...
Operator precedence comes in to play
1000 ?? 0 - 540 ?? 0 is equal to 1000 ?? (0 - 540) ?? 0 which is 1000
MedericPost Patron
Post PatronHello lbendlin
Thank you for your reply and these clarifications,
Unfortunately, it doesn't work in my case,
I tried in the 2 versions of Excel: Microsoft Office Pro Plus 2019 and Microsoft 365.
In the article, method 1 has 2 steps : Replace and subtract
Method 2 is supposed to do this in 1 step with only Coalesce
The screenshots below, which I have copied from the article, show that the result is not the same
Best reagards
- AlienSx
Super User
Operator precedence comes in to play
1000 ?? 0 - 540 ?? 0 is equal to 1000 ?? (0 - 540) ?? 0 which is 1000
