prob with conditional formatting formula

  • Thread starter Thread starter Fronyo
  • Start date Start date
F

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
 
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
 
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
 
gaftalik said:
*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 *
Click to expand...

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.
 
gaftalik said:
*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 *
Click to expand...

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
 
gaftalik said:
*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 *
Click to expand...

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
 
Back
Top