Add on to formula

  • Thread starter Thread starter ss
  • Start date Start date
S

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
 
بتاريخ الجمعة، 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
Click to expand...

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?
 
بتاريخ الجمعة، 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
Click to expand...

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)
 
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)
Click to expand...

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


Regards
Claus B.
 
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.
Click to expand...
Many thanks that works perfectly.
 
Back
Top