if the cell D3 is empty… then it should ignore the next formula…how we give this formula in excel

Hi

We can use read cell activity and get the output as a string variable named Strinput where mention range as “D3”

Then use a if activity with a condition like

**String.IsNullOrEmpty(Strinput.ToString.Trim)**

If true it means as empty then it goes to then block where you can proceed with next cell in same way

Cheers @Bhargavi_Lokapur

It’s better if you use Datatable and write as @Palaniyappan suggested

If it didn’t works for you, better give some more inputs with some screenshots

Thanks

I dont want to apply it in uipath. I want to apply this formula in excel

Original formula

=CONCATENATE(TRIM(LEFT(D2, FIND("^",SUBSTITUTE(D2, " “, “^”,2)&”^")))," “,“INV NO”,”-",E2," “,TRIM(LEFT(D3, FIND(”^",SUBSTITUTE(D3, " “, “^”,2)&”^")))," “,“INV NO”,”-",E3," “,TRIM(LEFT(D4, FIND(”^",SUBSTITUTE(D4, " “, “^”,2)&”^")))," “,“INV NO”,”-",E4," “,TRIM(LEFT(D5, FIND(”^",SUBSTITUTE(D5, " “, “^”,2)&”^")))," “,“INV NO”,”-",E5)

Output-DYNAMIC AGRO INV NO-DAI-168/01/21-22 INV NO- INV NO- INV NO-

expected O/P:-DYNAMIC AGRO INV NO-DAI-168/01/21-22

here if D3 is blank …then next formula should ignore and “INV NO” which is manually written… it should not write.

Original formula:-

=CONCATENATE(TRIM(LEFT(D2, FIND("^",SUBSTITUTE(D2, " “, “^”,2)&”^")))," “,“INV NO”,”-",E2," “,TRIM(LEFT(D3, FIND(”^",SUBSTITUTE(D3, " “, “^”,2)&”^")))," “,“INV NO”,”-",E3," “,TRIM(LEFT(D4, FIND(”^",SUBSTITUTE(D4, " “, “^”,2)&”^")))," “,“INV NO”,”-",E4," “,TRIM(LEFT(D5, FIND(”^",SUBSTITUTE(D5, " “, “^”,2)&”^")))," “,“INV NO”,”-",E5)

Output-DYNAMIC AGRO INV NO-DAI-168/01/21-22 INV NO- INV NO- INV NO-

expected O/P:-DYNAMIC AGRO INV NO-DAI-168/01/21-22

here if D3 is blank …then next formula should ignore and “INV NO” which is manually written… it should not write.

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