prob with conditional formatting formula

[Fronyo]

I am basically familiar with Excel 2000 but still a novice. This is th
formula that I am trying to conditional format.
=IF(SUM(B7:K7)=0,N6+M7-T7,(SUM(B7:K7)+M7+N6-T7)). If after seeing thi
so far, your surprised that it works so am I. B7 through K7 ar
various income columns. N6 is the previous CASH balance, M7 is anothe
cash income column which is not taxed and T7 is a CASH payout column.
Question - How do I write the formula in Cond. Format. to show a blan
or invisible entry in column N6 if there is no activity in B7:K7 or M7
T7. I can only get part way there with =IF(SUM(B7:K7)=0,N6). Pleas
excuse for being so wordy. Thanking you in advance for you
consideration - Frony

 

[gaftalik]

Hi,

I dont know if this is what you need , please try :

=if(or(sum("your range")=0;sum('your2nd range)=0;"";N6))

I hope this will help you

Rgds,
Gaftali

 

[gaftalik]

Sorry i forgot to explain ,

That will return a blank cell if any of the sum of those range
selected by you are equal to 0 , if not they will return cell N6

Good luck !
gaftali

 

[Fronyo]

*Hi,

I dont know if this is what you need , please try :

=if(or(sum("your range")=0;sum('your2nd range)=0;"";N6))

I hope this will help you

Rgds,
Gaftalik *

Hi Thanks for the response - I tried it and checked it twice and got
back "The formula you typed contains an error". Is this the formula
that I am to type in the formula section under or in conditional
formatting.

 

[Fronyo]

*Sorry i forgot to explain ,

That will return a blank cell if any of the sum of those range
selected by you are equal to 0 , if not they will return cell N6

Good luck !
gaftalik *

That would be what I want. Now for the stupid question did you mea
for this formula to be typed into my worksheet or in to the conditiona
formatting formula section

 

[Fronyo]

*Sorry i forgot to explain ,

That will return a blank cell if any of the sum of those range
selected by you are equal to 0 , if not they will return cell N6

Good luck !
gaftalik *

That would be what I want. Now for the stupid question did you mea
for this formula to be typed into my worksheet or in to the conditiona
formatting formula section