Nesting IF ISBLANK with AND Function

[shaheryar]

Hello everyone,

I'm facing a difficulty to get required results, I have applied the required formula trying to find the solution for specific cell if there is no value then next cell will be empty otherwise it will calculate as per formulated in cell. =IF(AND(($D5+$E5+SUM($G5:$H5)-$F5)=$D5,C5<0),"",($D5+$C5+$E5+SUM($G5:$H5)-$F5))

 

[KRice]

Welcome to the Board. I'm not sure I follow all of the logic, but have a look at this and let me know if this is what you want to achieve. You can click on the clipboard icon in the upper left (intersection of rows and columns) and then paste into a blank worksheet in cell A1 to try it out.

MrExcel20210409.xlsm
	A	B	C	D	E	F	G	H
1			Val	Bal	Cred	Deb	CoComm	CuComm
2	1			35000
3	2		1000	35000
4	3			36000		5000	10	20
5	4			31030
6	5			31030
7	6			31030	1000	500	10	30
8	7			31570
9	8			31570
Sheet1

Cell Formulas
Range	Formula
D3:D9	D3	=$D$2+SUM(C$2:C2,E$2:H2)-2*SUM(F$2:F2)

 

[shaheryar]

Welcome to the Board. I'm not sure I follow all of the logic, but have a look at this and let me know if this is what you want to achieve. You can click on the clipboard icon in the upper left (intersection of rows and columns) and then paste into a blank worksheet in cell A1 to try it out.

MrExcel20210409.xlsm
	A	B	C	D	E	F	G	H
1			Val	Bal	Cred	Deb	CoComm	CuComm
2	1			35000
3	2		1000	35000
4	3			36000		5000	10	20
5	4			31030
6	5			31030
7	6			31030	1000	500	10	30
8	7			31570
9	8			31570
Sheet1

Cell Formulas
Range	Formula
D3:D9	D3	=$D$2+SUM(C$2:C2,E$2:H2)-2*SUM(F$2:F2)

Thank you very much.

Also if it is possible to add formula for blank cell, like if there is no data filled in column C,E,F,G,H then the next cells in column D will remain blank until any value will get filled relevent cells.

 

[KRice]

Like this? This checks the count of cells on the preceding line that contain numbers (in col C, E, F, G, and H)...and if the count is >0, then the sum is displayed.

MrExcel20210409.xlsm
	A	B	C	D	E	F	G	H
1			Val	Bal	Cred	Deb	CoComm	CuComm
2	1			35000
3	2		1000
4	3			36000		5000	10	20
5	4			31030
6	5
7	6				1000	500	10	30
8	7			31570
9	8
Sheet1

Cell Formulas
Range	Formula
D3:D9	D3	=IF(COUNT(C2,E2:H2)>0,$D$2+SUM(C$2:C2,E$2:H2)-2*SUM(F$2:F2),"")