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="",Q 4="",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?
--


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


Scoober


"Scoober" wrote:

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="",Q 4="",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?
--


Scoober

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
---------------
Jacob Skaria


"Scoober" wrote:

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


Scoober


"Scoober" wrote:

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="",Q 4="",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?
--


Scoober