Write formula in excel Exception from HRESULT: 0x800A03EC

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)

New Microsoft Excel Worksheet.xlsx (1.6 MB)

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

it’s working thank you :slight_smile:

1 Like

ur welcome

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