Blank Cells

[Shapper]

Hello,

I am trying to do the following:

1 - In Cell A4 display the SUM of A1 + A2 + A3 if at least one of these cells is not empty.

2 - In Cell A6 display A5-A4 if both cells are not empty.

How can I do this?

Thank You,
Miguel

 

[Jim Cone]

= Sum(A1:A3)
...and...
=IF(AND(LEN(A5),LEN(A4)),A5-A4,"")

--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(free and commercial excel programs)




"Shapper" <[email protected]>
wrote in message
news:25110584.2678.1325119728434.JavaMail.geo-discussion-forums@yqnd19...

 

[prestonplace]

Hello,

I am trying to do the following:

1 - In Cell A4 display the SUM of A1 + A2 + A3 if at least one of these cells is not empty.

2 - In Cell A6 display A5-A4 if both cells are not empty.

How can I do this?

Thank You,
Miguel

Hi Miguel,

Probably a couple of ways those formulas could be written, but here is
how I would approach them:

Cell A4 =IF(OR(A1<>"",A2<>"",A3<>""),SUM(A1:A3),"")
Cell A6 =IF(AND(A4<>"",A5<>""),SUM(A4:A5),"")

Hopefully that helps.
Charles

 

[joeu2004]

I am trying to do the following:
1 - In Cell A4 display the SUM of A1 + A2 + A3 if at
least one of these cells is not empty.
=IF(COUNT(A1:A3)>0,SUM(A1:A3),"")

2 - In Cell A6 display A5-A4 if both cells are not empty.

=IF(COUNT(A4:A5)=2,A5-A4,"")