How to check if a cell Exists with any value or no value in an Excel. (we need boolean output)

Help Activities
, ,
1

Hi All,

How to check if a cell Exists with any value or no value in an Excel. (we need boolean output)

for example

In A7 Cells If there is any I have to come Then if there is none in A7 Cells I have to come Else

image

image

2

something like this

image
image1314×619 29.1 KB

3

Hi @jack.chan

thank you for reply

im getting error

image
image1351×469 24.4 KB

thanks,
RajKumar

4

dont use read range, use read cell

image
image434×519 8.9 KB

2 Likes
5

Hello @RajKumar_DC,

You need to create a variable of the cell you need to check.

If you know the cell, use read cell activity. Create a variable and then put it inside the if condition. :slight_smile:

1 Like
6

It work thank you so much :slightly_smiling_face:

1 Like
7

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