Thread: IF BLANK
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
HALinNY HALinNY is offline
external usenet poster
 
Posts: 31
Default IF BLANK



"Johnny" wrote:

Unforunately that did not work. The result of [If (sum(G4:K4)1,"","Blank")]
is (Blank) for every row.

"John" wrote:


That's good news, Johnny. You got rid of the #VALUE! errors. You are on
your way to success.

What you need to do now is tell us more about what you are doing. Maybe you
could show us a few rows of your data with actual values.

B+
HALinNY