Excel Formula Conversion

[Sarath27]

Hi All,

Pls help me with the below excel formula.  i need to write the formula if [Forward Starting]="No" then calculate the below and if [Forward Starting]="Yes" then apply as "0"

IF [Day]="Sun"
THEN (([Current Prin. Amt.]*([Trsy Rate]/100))/360)*3
ELSE (([Current Prin. Amt.]*([Trsy Rate]/100))/360)*3

ENDIF

[aatalai]

@Sarath27 try this

if [Forward Starting]="Yes" then 0

elseif   [Day]="Sun"
THEN (([Current Prin. Amt.]*([Trsy Rate]/100))/360)*3
ELSE (([Current Prin. Amt.]*([Trsy Rate]/100))/360)*3

Endif

[binuacs · Accepted solution]

@Sarath27 

IF [Forward Starting]="No" THEN
  IF [Day]="Sun" THEN (([Current Prin. Amt.]*([Trsy Rate]/100))/360)*3
  ELSE (([Current Prin. Amt.]*([Trsy Rate]/100))/360)*3
  ENDIF
ELSEIF [Forward Starting]="Yes" THEN 0
ELSE
Null()
ENDIF

[patrick_mcauliffe]

@Sarath27 I don't have an answer to this specific conversion, but just wanted to let you know I've had great success using ChatGPT or Bing Chat to do my conversions from other platforms to Alteryx.

[Sarath27]

Thanks much @binuacs, your solutions always worked.

[Kaustubh17]

HI @patrick_mcauliffe 

How we can do that can you elaborate more on that, because i am facing one of the challenge that in my excel i have formulas at each cell which is linked with other cells and sheets . my task  is to calculate few formulas which are on excel need to calculate on Alteryx to reduce the load on excel. Please request your help in these kind of situation.

Best Regards,

Kaustubh