topic Hello All, I am trying to… in Product Forum

Setting Excel Values with Formulas

UrielLander — Mon, 27 Aug 2018 23:10:00 GMT

Hello, I´m trying to set a value of a cell with a Formula. The way i´m trying to do it is via "Set Cell Value" action related to MS Excel VBO Object. Example: "=IF(AND(H19="&[Cond 1]&";S19

Does it work with simple…

AndreyKudinov — Tue, 28 Aug 2018 16:53:00 GMT

Does it work with simple text? Check where it fails within VBO - Go To Cell or Set Cell Value? If it is Go To Cell - check your Cell Reference.

Hello All, I am trying to…

AvinashPandey — Fri, 31 Aug 2018 10:09:00 GMT

Hello All, I am trying to pass the value in the cell using SET CELL Value function however it is throwing error ""HRESULT: 0x800A03EC"" The value is ""=IFERROR(VLOOKUP(B3,'C:\Users\avipande\Documents\Finance\[ConsolidatedReport.xlsx]Sheet1'!$A$1:$N$1600,1,FALSE),'Missing Employee')"" I have valdated it before running. However i have an error everytime (exception from HRESULT: 0x800A03EC) i run it and the formula is not entered into the cell. Has anyone worked and solved this problem? Thank you

RE: Hello All, I am trying to…

NeermalJankee — Thu, 05 Aug 2021 11:24:00 GMT

Hi Avinash,

I am facing the same issue. Have you been able to find a fix ?

------------------------------
Neermal Jankee
Senior RPA developer
SD Worx
Indian/Mauritius
------------------------------

RE: Hello All, I am trying to…

krishna.kodimurali9 — Thu, 05 Aug 2021 12:32:00 GMT

Hi Neermal,

We deal with very large excel formulas, we simply add the formula to a collection. Then use the Coll.Formula in the "Set cell value" stage. It works.

------------------------------
Murali
RPA Consultant
------------------------------

RE: Setting Excel Values with Formulas

ritansh.jatwani — Thu, 05 Aug 2021 20:01:00 GMT

Hi @Uriel Lander,

I am assuming that you are facing issues while trying to do "Set Cell Value" and trying to write the formula. It seems there is a syntax error of AND condition. Please refer the below sample:

I have used Yes and No as output depending on the condition matching with H19 and S19 cells.

------------------------------
Ritansh Jatwani Senior Consultant
Consultant
EY
Gurgaon
*If you find this post helpful mark it as best answer
------------------------------

RE: Hello All, I am trying to…

ritansh.jatwani — Thu, 05 Aug 2021 20:05:00 GMT

Hi @AvinashPandey,

Whenever you have to perform vlookup and the formula needs to be worked on some different workbook, then rather using the path in the formula and experiencing issues, it's better to copy paste the data in the destination workbook in a temp sheet so that vlookup works easily without causing any issues and also, its easier to understand the formula.
Regarding the error you are facing, are you trying to write the formula in a cell where already data exists?
Sometimes, the issue occurs due to that as well.

------------------------------
Ritansh Jatwani Senior Consultant
Consultant
EY
Gurgaon
*If you find this post helpful mark it as best answer
------------------------------

RE: Setting Excel Values with Formulas

michaeloneil — Fri, 13 Aug 2021 15:21:00 GMT

Hi Uriel

I've always found it a little easier to set the formula to a data item through a calculation stage then use the data item to set the cell value. It saves any hassle with quotation marks and similar things.

------------------------------
Michael ONeil
Technical Lead developer
Everis Consultancy
Europe/London
------------------------------