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

Ask for Help
1

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
image854×177 4.75 KB

2

Hi @Ry_Rey_Depositario :wave:t2:

  • 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?