Forum Discussion

Dan_Shermannavectis's avatar
Dan_Shermannavectis
Copper Contributor
Aug 15, 2021
Solved

Need help finding excel formula to subtract from balance only if text box is filled in

Can someone help develop a formula for my spreadsheet below.  I need column N "Remaining Balance" to calculate the balance from Column L "Approved Amount Infusion" minus Column S through V. But the f...
excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Aug 16, 2021

    Dan_Shermannavectis Personally, I'm not really fond of having empty rows within tables and I don't understand why you have created a one column structured table in the middle of a larger "regular" table.

     

    But, the following formula could do what you need if you get rid of the empty rows and structured table.

    =IF(A5<>"",IF(ISNUMBER(L5),L5-SUM(S5:V5),N4-SUM(S5:V5)),"")

     

    Not very elegant, but it works. See attached.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Aug 16, 2021

Dan_Shermannavectis Personally, I'm not really fond of having empty rows within tables and I don't understand why you have created a one column structured table in the middle of a larger "regular" table.

 

But, the following formula could do what you need if you get rid of the empty rows and structured table.

=IF(A5<>"",IF(ISNUMBER(L5),L5-SUM(S5:V5),N4-SUM(S5:V5)),"")

 

Not very elegant, but it works. See attached.

Resources