Hi,

Can you please help me to do the below iterations in Excel using Studio X,

Need to use the below model in excel using the data set below (model is only a one line, each row should replace the previous row values),

Model

Attendance Salary Current Month Salary Payable

(A) (B) (A * B)

Data set

Name Attendance Salary

(A) (B) ©

John 80% 100,000

Sarah 60% 60,000

Kevin 40% 50,000

The results should be written separately as follows,

Output

Name Current Month Salary Payable

John

Sarah

Kevin

Thank you in advance…