Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
RE: Leave final cell blank
2 views
Skip to first unread message
Scoober
Nov 12, 2009, 8:14:01 PM11/12/09
to
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="",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?
> --
>
>
> Scoober
Scoober
Nov 12, 2009, 8:11:02 PM11/12/09
to
Jacob Skaria
Nov 12, 2009, 8:41:02 PM11/12/09
to
Try the below...
'if you have only +ve numbers
=IF(SUM(C4:R4)=0,"",B4-SUM(C4:R4))
'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
0 new messages