Nested IF function with additional subtraction

[CFuser87]

Hi,

I found a lot of formulas stating how an if function would work if it's under a certain threshold,

Just wondering how I would translate the following formula from Excel into Alteryx using the formula tool.

Would it be possible to keep it in one formula even with the subtraction since I need it for multiple columns?

=IF
End NBV (PY) - If (End NBV (PY) >0, Amort (PY), 0 ) >0,
End NBV (PY) - If (End NBV (PY) >0, Amort (PY), 0 )
0)

Thanks

[Raj · Accepted solution]

@CFuser87 please find the formula attached.

IF [End NBV (PY)] - IIF([End NBV (PY)] > 0, [Amort (PY)], 0) > 0 THEN [End NBV (PY)] - IIF([End NBV (PY)] > 0, [Amort (PY)], 0) ELSE 0 ENDIF

mark done if solved.

[CFuser87]

Amazing! Thanks for the quick reply!