Hello,
I am attempting to add a custom logical column in an excel power query. The new column should be a 0 or 1 based on whether the number in columns a or b are less than or greater than 1. Attached below is a spreadsheet with some data to explain what I am trying to achieve. With the code below i am able to get the column I desire, however, when there is a null value in column A, and the corresponding cell in column b does have a value, the calculated cell in the custom column results in an error. I would like the formula to ignore cells that are null and calculate using the non-empty cell. For instance, cell in column a is null, cell in column b is 1.5 my code below throws an error, but i would like it to return a value of 1 for being greater than 1.
![]()
Please Login or Register to view this content.
Thank you in advance.
Bookmarks