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.