Write formula in excel Exception from HRESULT: 0x800A03EC

Help
, ,
1

Hi there,
I want to compare three excel column.
Within three cell value at least two value must be bigger than zero. How can I formulate this in write cell activities.
ı tried formula this(=IF(IF(AND(A2>0;B2>0);1;0)+IF(AND(A2>0;C2>0);1;0)+IF(AND(C2>0;B2>0);1;0)>0;1;0)) ı used write cell activity but it’s not working When ı use write cell activity ,ı get exception this(The range does not exist. ----> System.Runtime.InteropServices.COMException:Exception from HRESULT: 0x800A03EC)

image
image1836×1004 76.2 KB

New Microsoft Excel Worksheet.xlsx (1.6 MB)

2

Hi burcu_argun,
Use Variable with datatype String and then write the formula in variable and pass it,
it will work i have tried with the same excel sheet and it is working.
Check the attached XAML file

Sequence.xaml (5.8 KB)

1 Like
3

it’s working thank you :slight_smile:

1 Like
4

ur welcome

5

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