IF Ranges

[Alby]

I just posted a reply to show nothing if cells are blank

IF B9 =5 C9=1 D9=2 E9=3 F9=

=IF(C9+D9+E9+F9=0,"",(C9+D9+E9+F9)-B9

IF C9 thru F9 =0 then the result in G9 = blan
IF C9 thru F9 = 10 then result in G9 = 5 (10-5

If I were to write the formula
=IF(C9:F9=0,"",(C9:F9)-B9
The result is "VALUE

How do I get around that?

 

[Paul]

I just posted a reply to show nothing if cells are blank:

IF B9 =5 C9=1 D9=2 E9=3 F9=4

=IF(C9+D9+E9+F9=0,"",(C9+D9+E9+F9)-B9)

IF C9 thru F9 =0 then the result in G9 = blank
IF C9 thru F9 = 10 then result in G9 = 5 (10-5)

If I were to write the formula:
=IF(C9:F9=0,"",(C9:F9)-B9)
The result is "VALUE"

How do I get around that?

=IF(SUM(C9:F9)=0,"",SUM(C9:F9)-B9)

 

[Alby]

Thanks Paul, much appreciated