Excel conditions

Help Activities
1

i have excel file.

Column A ColumnB
1 #N/A
2 3
3 5

If Column B contain #N/A it should show false.

2

HI @Ak_4

  • Read range the excel and store them in a datatable.
  • For each row in datatable
    • If Condition will be like
Not CurrentRow("ColumnB").ToSTring.Trim.Contains("#N/A")

this condition will go to then only if the value of the Column B not equal to #N/A

Regards
Sudharsan

3

Thank for your help its working.

Can u help me in this case if ColumnB contain
negative value it should give false.

4

@Ak_4 Use this condition

Not CurrentRow("ColumnB").ToSTring.Trim.Contains("#N/A") or Not  Cint(CurrentRow("ColumnB").ToSTring.Trim)<0

Regards
Sudharsan

5

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