Excel, if condition

Help Activities
, , ,
1

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 ?

2

Hey,
You can use Read cell activity and read both the cell and use if condition and then you can use write cell activity

Thanks,
Rounak

3

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”,“”))

Regards,
Rohith

5

Thank you @rohith.prabhu and @Rounak_Kumar1

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.