Hello Experts,
I need your help to build my first multi row calculation workflow. I am able to calculate the values in excel with the help of below formula.
If Column B has a value "DF" then I need calculation based on column B value "TR" and corresponding target value in column "C".
Column "E" holds the decimal point value. Output should be in same decimal point as value-maintained column "E". Could you Pls guid me how to achieve this.
Formula used in column "F" under calculated values.
=IFERROR(IFS($B4="DF",FIXED(($C2*$D4)/100,$E4)),"")
