Apologies if this is in the wrong section.
I am using power query editor to clean some data before importing.
I want to convert a number to zero in one cell based on info in another cell.
It is simply if [P-Code]= 0 change value in [Unit Price] to zero, otherwise no change.
I'm only just starting and don't know the syntex for these formula's yet.
Thanks
Bookmarks