EXCEL IF THEN STATEMENT FOR CELLS

[ehedgepeth1]

I have an excel document that I pulled into blue prism as a collection.
I want to populate all of Column O but it depends on what Column A states.

I want to type IF Column A says "Document80" THEN type "Corrected4" in Column O.

What Action do I use? What formula do I type in?

 

[NPoornima]

I have an excel document that I pulled into blue prism as a collection.
I want to populate all of Column O but it depends on what Column A states.

I want to type IF Column A says "Document80" THEN type "Corrected4" in Column O.

What Action do I use? What formula do I type in?

Hi, If Blank column is not there in collection then add it using below:
First add text field into the collection.
VBO = Utility - Collection Manipulation
Collection Name = Test_Coll
Action = Append Field(Text)
Field Name = "Col_O"

Note: Collection Name & Field Name I had given some example values

Then add loop stage using the collection.
Within loop stage, add decision as
[Column A]="Document80" then
Yes path, Create Calculation stage and set as "Corrected4" in Test_Coll.Col_O and then connect to Loop End stage.
No path, connect to Loop End stage.

Please post the update/status

 

[ehedgepeth1]

Thank you append field text works.

 

[dost7189]

1) Create your new spreadsheet by going to "File" and then "New."
2) Create an empty cell C2.
3) Fill in the name of your condition for this formula below, getting tricky or using a big word isn't necessary.
4) Copy what is in the following conditional statement that corresponds with the cell where you want this condition to show up, and paste it into cell C2 as shown below.
5) If you want this statement to span multiple cells or match some cells that don't need one just copy-paste it until you've set all those cells where needed. (See example below.)

 

[SERBEM]

I would import data to a collection and make a loop to do this check/correction