# Calculate the cell until a certain cell is filled with a name in Excel, otherwise blank

**URL:** <https://community.glideapps.com/t/calculate-the-cell-until-a-certain-cell-is-filled-with-a-name-in-excel-otherwise-blank/33427>\
**Category:** Ask for Help\
**Created:** [October 21, 2021, 11:59pm UTC](https://community.glideapps.com/t/calculate-the-cell-until-a-certain-cell-is-filled-with-a-name-in-excel-otherwise-blank/33427 "2021-10-21T23:59:10Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ry\_Rey\_Depositario](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ry_rey_depositario/32/33325_2.png) [@Ry\_Rey\_Depositario](https://community.glideapps.com/u/Ry_Rey_Depositario)\
**Post date:** [October 21, 2021, 11:59pm UTC](https://community.glideapps.com/t/calculate-the-cell-until-a-certain-cell-is-filled-with-a-name-in-excel-otherwise-blank/33427/1 "2021-10-21T23:59:10Z")

</div>

I’m attempting to load a business inventory. Initially, I intended for C5 and F5 to be vacant until B5 was filled with customer names. I’m currently using =C5-D5+E5 for F5 to compute the remaining load balance after the load is initiated. The value of C5 is (=F4), which is obviously dependent on the value of F4.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/2/521382cf1247677d052f0670d1501b44fcee6d81.png)

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [October 22, 2021, 12:03am UTC](https://community.glideapps.com/t/calculate-the-cell-until-a-certain-cell-is-filled-with-a-name-in-excel-otherwise-blank/33427/2 "2021-10-22T00:03:45Z")

</div>

Hi @Ry_Rey_Depositario 👋🏻

- What’s your question?
- Have you considered building your logic in av Glide Table rather than in Google Sheets?
- What will be the use experience? How will the data be populated in your columns?
