Leave final cell blank

  • Thread starter Thread starter Scoober
  • Start date Start date
S

Scoober

With the formula below S3 is populated with the correct answer.

=(IF(AND(B4="",C4="",D4="",E4="",F4="",G4="",H4="",I4="",J4="",K4="",L4="",M4="",N4="",O4="",P4="",Q4="",R4=""),"",(B4-C4-D4-E4-F4-G4-H4-I4-J4-K4-L4-M4-N4-O4-P4-Q4-R4)))

However when i C&P this formula into S4 i get #Value! because cells B4 thru
R4 are empty. How can i change the above formula so S4 remains blank if no
figures are entered into cells B4 thru R4?
 
Above is not quite right.

In the equation set out in S4 all other cells thru C4 thru R4 are empty but
b4 has a value in it.
 
Try the below...
'if you have only +ve numbers
=IF(SUM(C4:R4)=0,"",B4-SUM(C4:R4))

'if you have negative numbers
=IF(COUNT(C4:R4)=0,"",B4-SUM(C4:R4))

If this post helps click Yes
 
Back
Top