Combining If statements in load script

[#1]

Hello,

I`m trying to combine to If statements on a load script for calculation purposes.

Seperately they give good results,

But If I combine using or it generates results at the right values except the generated result is only 1 instead the actual amount

If([Type]=2,IF( "Qty_ to Ship" > 0, "Line Amount")) as  RunningSalesLineAmount,

  If([Type] =1,If([No_] like '8*',"Line Amount")) as RunningSalesLineAmount,

any help would be appreciated

[#2 · Accepted solution]

I found the solution,

It was the if then else function used properly ..

IF( "Qty_ to Ship" > 0,If([Type]=2, "Line Amount",If([Type] =1,If([No_] like '8*',"Line Amount")))) as RunningSalesLineAmount,