Read Cells Formula

Help Activities
, ,
1

Hello there,

I have 2 questions which I would like to consult you:

  1. I would like to read all cells formula within an excel sheet, hence i put the range as " " to read the whole sheet. However, I am not sure why there is a warning “Read Cell Formula: Cell argument is invalid”.

image
image1307×694 44.4 KB

  1. I would like to set “if condition” with a log message IF the formula starts with (“#”), such as “#DIV/0!” or “ref!”. However, the if condition in the picture which I have written is not working. Can I seek for your guidance?

Thank you in advance!

2

@WS_Chai

Using read cell you only able to read a cell not an entire Sheet

3

Hi @WS_Chai

Read cell formula is used to read a specific cell in an excel sheet. If you have to read a particular cell you can use Read Cell Formula.

image

Regards,

4

Hi @WS_Chai

In the Read cell formula activity you haven’t give the cell range like A1.
Check the below image for better understanding.
image

Hope it helps!!