Leave final cell blank


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?
 
Ad

Advertisements

S

Scoober

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.
 
Ad

Advertisements

J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top