# Excel formula

**URL:** <https://community.automationedge.com/t/excel-formula/2355>\
**Category:** Get Help & Discuss\
**Tags:** rpa\
**Created:** [July 13, 2020, 10:28am UTC](https://community.automationedge.com/t/excel-formula/2355 "2020-07-13T10:28:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Krutika](https://avatars.discourse-cdn.com/v4/letter/k/a9a28c/32.png) [@Krutika](https://community.automationedge.com/u/Krutika)\
**Post date:** [July 13, 2020, 10:28am UTC](https://community.automationedge.com/t/excel-formula/2355/1 "2020-07-13T10:28:34Z")

</div>

Hi,

When reading from excel can we alse read the formula which a cell has been allocated and then apply that formula in other steps?

---

<div class="post-metadata">

**Author:** ![aesupport](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.automationedge.com/aesupport/32/371_2.png) [@aesupport](https://community.automationedge.com/u/aesupport)\
**Post date:** [July 13, 2020, 11:01am UTC](https://community.automationedge.com/t/excel-formula/2355/2 "2020-07-13T11:01:17Z")

</div>

Yes, we can apply the formulae on excel data using Process studio’s various Steps, but we’ve to read the formula from excel manually.

---

<div class="post-metadata">

**Author:** ![Krutika](https://avatars.discourse-cdn.com/v4/letter/k/a9a28c/32.png) [@Krutika](https://community.automationedge.com/u/Krutika)\
**Post date:** [July 13, 2020, 11:16am UTC](https://community.automationedge.com/t/excel-formula/2355/3 "2020-07-13T11:16:58Z")

</div>

So you mean to say  
a sheet has data with formula I will read the data using steps and apply the formula on data and then write the data in excel back?  
but will the formula be preserved in excel after writing the data?

---

<div class="post-metadata">

**Author:** ![aesupport](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.automationedge.com/aesupport/32/371_2.png) [@aesupport](https://community.automationedge.com/u/aesupport)\
**Post date:** [July 13, 2020, 11:34am UTC](https://community.automationedge.com/t/excel-formula/2355/4 "2020-07-13T11:34:18Z")

</div>

Yes, right. Need one change in this, If you require to cross check the calculations performed using PS Steps then, don’t write output in original excel which you get as input, instead use another one.