show nothing if the cell is blank

  • Thread starter Thread starter jc
  • Start date Start date
J

jc

Can you make a formula out of this:
If column C,D,E,F has nothing then show nothing in
column G, otherwise c8:f8 - b8

Thanks.

jc
 
Hi

All of them don't contayn nothing, or any of them contains nothing?
Are you checking whole columns, or values in row 8?

With value checking for row 8:

=IF(AND(C8="",D8="",E8="",F8=""),"",C8/F8.B8)
returns nothing when all cells in range C8:F8 are empty

=IF(OR(C8="",D8="",E8="",F8=""),"",C8/F8.B8)
returns nothing when any cell in range C8:F8 is empty
 
Arvi,

Ive been getting a #value!

the sum_range you indicated "C8/F8:B8", what is that mean?
is it the same with (C8:F8)-B8

also, if you don't mine, can you please add on this
formula that when all range of c15:c34 is blank, show
blank.

=SUMIF(BFS3!$C$15:$C$34,"Contract Service",BFS3!
$E$15:$E$34)

For your kind assistance.

Thanks in advance.

jc
 
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

Hope that helped
 
Hi

There was a typo, of-course it was 'C8/F8-B8'.

About SUMIF-formula:

Do you want the formula return nothing when there isn't any entry equal to
'Contact Service' in range BFS3!$C$15:$C$34, or you do want exactly what you
asked? When the first is the case, then
=IF(COUNTIF(BFS3!$C$15:$C$34,"Contract
Service")=0,"",SUMIF(BFS3!$C$15:$C$34,"Contract Service",BFS3!$E$15:$E$34))
When second is the case, then
=IF(COUNTIF(BFS3!$C$15:$C$34,"<>")=0,"",SUMIF(BFS3!$C$15:$C$34,"Contract
Service",BFS3!$E$15:$E$34))
(with no 'Contract Service' in range BFS3!$C$15:$C$34, but any other entry
present there, 0 is returned)
 
Back
Top