Forum Discussion
IF and Statement in Excel Power Query
in the example data you gave the Amount_A values were null.
Changed the code so it works with = 0 too 🙂if [Amount_A] = null or [Amount_A] = 0 then
if [Amount_C] = null or [Amount_C] = 0 then
if [Amount_B] = 0 or [Amount_B] = nullthen null
else "Expiring"
else "Renewed"
else [Type]
in the example data you gave the Amount_A values were null.
Changed the code so it works with = 0 too 🙂
if [Amount_A] = null or [Amount_A] = 0 then
if [Amount_C] = null or [Amount_C] = 0 then
if [Amount_B] = 0 or [Amount_B] = null
then null
else "Expiring"
else "Renewed"
else [Type]
my bad .. I changed it to 0 in last moment while uploading to make it more simple which missed your first line of code.. thank you so much
Glad I could help!