Excel Formula Conversion

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

Data Investigation

Accepted answers

binu_acs

@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

All comments

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

binu_acs

@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 @binu_acs, 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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703