In the excel sheet suppose the cell A1= “Yes” and cell A2= “Yes” i want to write A4=" Yes". If it is A1=“Yes” and A2=“No” then i want to write A4=“No”. How do i do it ?
You can use Read cell activity and read both the cell and use if condition and then you can use write cell activity
Hello @RACHEL_PAUL ,
You can achieve it in multiple ways :
Using Read Cell :
Use Read cell and read the values from cell A1, A2, store it in 2 String variables StrA & StrB.
Use write cell and in Cell content write If ((StrA = “Yes” And StrB = “Yes”),“Yes”, If ((StrA = “Yes” And StrB = “No”),“No”,“”))
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.