#DIV/0! error

[mwvirk]

the entire row is working fine and I just noticed that if there is no value in C then G J K are giving #DIV/0! error
is there a way to fix it without changing other formulas? but of course, if you can correct my existing formulas, I will be more than happy for your support.
thank you.

MWVirk PSX Portfolio v0004.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
124	19-Sep-2024	MARI	0	10	1340.00%	0.00	#DIV/0!	15.00%	0.00	#DIV/0!	#DIV/0!	0.00	No		800.00%	0	No
PSX Payouts Status

Cell Formulas
Range	Formula
C124	C124	=IF(B124="","",SUMIFS('PSX Trading'!G:G,'PSX Trading'!A:A,B124,'PSX Trading'!C:C,"<>Closed",'PSX Trading'!F:F,"<"&A124) + SUMIFS('PSX Trading'!G:G,'PSX Trading'!A:A,B124,'PSX Trading'!C:C,"Closed",'PSX Trading'!AD:AD,">="&A124,'PSX Trading'!F:F,"<"&A124))
D124	D124	=IFERROR(VLOOKUP(B124,'PSX Shopping List'!A:CD,2,0),"")
F124	F124	=IF(AND(C124<>"",E124<>""),((C124*E124)*D124),"")
G124	G124	=IF(AND(C124<>"",F124<>""),F124/C124,"")
H124	H124	=IF(E124="","",IF((ISNUMBER(FIND("SPWL",B124))+ISNUMBER(FIND("KOHE",B124))+ISNUMBER(FIND("HUBC",B124)))>0,0.075,0.15))
I124	I124	=IF(AND(F124<>"",H124<>""),F124*H124,"")
J124	J124	=IF(AND(G124<>"",K124<>""),G124-K124,"")
K124	K124	=IF(AND(C124<>"",L124<>""),L124/C124,"")
L124	L124	=IF(AND(F124<>"",I124<>""),F124-I124,"")
P124	P124	=IF(AND(C124<>"",O124<>""),TRUNC(C124*O124*IF(A124>=DATE(2023,7,1),0.9,1)),"")

Named Ranges
Name	Refers To	Cells
'PSX Shopping List'!_FilterDatabase	='PSX Shopping List'!$A$1:$CC$1	D124
'PSX Trading'!_FilterDatabase	='PSX Trading'!$A$1:$BV$1201	C124

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
O2:P1200,R2:R1200	Expression	=AND($R2<>"",$O2<>"")	text	NO
O2:P1200,R2:R1200	Expression	=$O2<>""	text	NO
H2:H1200	Cell	contains a blank value	text	NO
H2:H1200	Cell Value	<>0.15	text	NO
E2:H1200,J2:K1200,N2:N1200	Expression	=AND($N2<>"",$E2<>"")	text	NO
E2:H1200,J2:K1200,N2:N1200	Expression	=$E2<>""	text	NO
B2:B1200	Expression	=OR("SPWL"=B2,"KOHE"=B2,"HUBC"=B2)	text	NO
D2:D1200	Cell Value	<>10	text	NO
M2:M1200	Cell Value	contains "No"	text	NO
M2:M1200	Cell Value	contains "Yes"	text	NO
Q59:Q1200	Cell Value	contains "No"	text	NO
Q59:Q1200	Cell Value	contains "Yes"	text	NO

 

[Micron]

Test for >0, not "" ?

 

[mwvirk]

Test for >0, not "" ?

please mark the cell where i should change it to >0 instead of ""
Do you mean?

i tried >0 and still getting this:

MWVirk PSX Portfolio v0004.xlsx
	G	H	I	J	K
124		15.00%	0.00	#VALUE!
PSX Payouts Status

Cell Formulas
Range	Formula
G124	G124	=IF(AND($C$124>0,$F$124>0),$F$124/$C$124,"")
H124	H124	=IF(E124="","",IF((ISNUMBER(FIND("SPWL",B124))+ISNUMBER(FIND("KOHE",B124))+ISNUMBER(FIND("HUBC",B124)))>0,0.075,0.15))
I124	I124	=IF(AND(F124<>"",H124<>""),F124*H124,"")
J124	J124	=IF(AND(G124>0,K124>0),G124-K124,"")
K124	K124	=IF(AND(C124>0,L124>0),L124/C124,"")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H2:H1200	Cell	contains a blank value	text	NO
H2:H1200	Cell Value	<>0.15	text	NO
E2:H1200,J2:K1200,N2:N1200	Expression	=AND($N2<>"",$E2<>"")	text	NO
E2:H1200,J2:K1200,N2:N1200	Expression	=$E2<>""	text	NO

 

[Micron]

if there is no value in C

In your row 124 that is not true - there is zero:

so for where you use division, at least test the divisor for not being zero rather than testing for "" so for example
not
=IF(AND(C124<>"",F124<>""),F124/C124,"")

but
=IF(AND(C124>0,F124<>""),F124/C124,"")

Sorry if I picked the wrong formula but it looked like a good example to me. The important thing is to make sure you test the divisor for not being zero. If it can be negative then

=IF(AND(C124<>0,F124<>""),F124/C124,"")
That assumes C124 is the divisor. Not sure what you'd get if you end up dividing "" by something that <> 0. Based on that possibility, my suggestion may not be robust enough.