#value! and I want cell to be blank

[gocolonel77]

Cell F4 contains the following formula which is returning #value!

=IF(ISBLANK(E4),"",(1-E4/177))

Cell E4 which cell F4 draws data from contains

=(IF(AND(ISBLANK(H4),ISBLANK(K4),ISBLANK(N4),ISBLANK(Q4)),"",H4+K4+N4+Q4))

If i enter data into any cell H4, K4, N4 or Q4 the error message goes away in F4 and displays correct data. But what i want is for cell F4 to remain blank instead of the #value!.

Any suggestions and reason why this is happening.
Thanks in advance.
Jason

[AlKey]

Try this

=IF(E4="","",1-(E4/177))


=IF(AND(H4="",K4="",N4="",Q4=""),"",SUM(H4,K4,N4,Q4))

[AlKey]

Thank you for the feedback!