Add on to formula

[ss]

In M7 I have =C24+179
C24 is =MAX(C12:C17)

How would I alter this so that if cells C12:C17 are blank then cell M7
will show a blank, it currently displays 27/6/1900 as a date until the
information is entered in C12:C17

 

[viaexcel.ar]

بتاريخ الجمعة، 5 سبتمبر، 2014 UTC+3 1:10:04 م، كتب ss:

In M7 I have =C24+179

C24 is =MAX(C12:C17)



How would I alter this so that if cells C12:C17 are blank then cell M7

will show a blank, it currently displays 27/6/1900 as a date until the

information is entered in C12:C17

Excel currently shows 179 but in date format, if you change M7 format to general for example, you will see 179 because blank+179 = 179. is this the value you are looking for or you want blank+179 = blank?

 

[viaexcel.ar]

بتاريخ الجمعة، 5 سبتمبر، 2014 UTC+3 1:10:04 م، كتب ss:

In M7 I have =C24+179

C24 is =MAX(C12:C17)



How would I alter this so that if cells C12:C17 are blank then cell M7

will show a blank, it currently displays 27/6/1900 as a date until the

information is entered in C12:C17

So, If you are looking for the following:

if the range C12:C17 is blank ( all cells ), the M17 should return 0, try following Array Formula

=IF(AND(ISBLANK(C12:C17)),0,MAX(C12:C17)+179)

(type it in M17 and then press CTRL+SHIFT+ENTER)

 

[Claus Busch]

Hi,

Am Fri, 5 Sep 2014 03:26:30 -0700 (PDT) schrieb (e-mail address removed):

=IF(AND(ISBLANK(C12:C17)),0,MAX(C12:C17)+179)

(type it in M17 and then press CTRL+SHIFT+ENTER)

without array formula:
=IF(COUNT(C12:C17)=0,"",C24+179)


Regards
Claus B.

 

[ss]

Hi,

Am Fri, 5 Sep 2014 03:26:30 -0700 (PDT) schrieb (e-mail address removed):


without array formula:
=IF(COUNT(C12:C17)=0,"",C24+179)


Regards
Claus B.

Many thanks that works perfectly.