Hello, I want to create a function that checks if in an excel Data table in a row the cell in column A is filled + in column B if the cell says “order executed”. How do I write this together in one if statement? Thank you!

Check two columns in datatable

Edwin_Barahona (Edwin Barahona) November 8, 2022, 9:16pm 2

Try using this condition, that should to the trick.

not String.IsNullOrEmpty(dt_YourTable("ColumnA").ToString) and dt_YourTable("ColumnB").ToString.ToLower.Equals("order executed")

Topic		Replies	Views
Identify empty cells in DataTable Help datatable , excel , activities , question	6	2080	November 21, 2019
Check if a datatable contains rows with Null or Blanks in any Column/Cells Activities datatable , excel , activities , question	2	4887	May 10, 2021
How to Check Excel 2 null or empty Columns Academy Feedback	13	2667	April 23, 2019
Condition to check the column is blank or not in datatable Studio datatable , studio , question , linq	5	400	January 15, 2024
Query to remove datatable Activities excel , activities , question	7	345	June 6, 2023