Functions

Cell Formats & Hiding
Hi I have a worksheet I use frequently, where some cells have zero values. For presentation's sake, I hide rows where the value is zero, and this I do manually. The zero vales can and do change. How do I write a macro to hide cells with zero values? TIA GDS "Let's roll!" ... 22 Mar 2010 04:59

Help with conditional formatting...
This may sound like a basic question. But I am trying to set up some conditional formatting based on varying text in Excel 2003. I am sorting baseball players and their stats. First I want the cells in the entire row to be one color if they are on a team listed in column B. Second I want it to be a differen... 20 Mar 2010 23:17

Shade a Cell
How can I shade a cell in Excel 2003 but when I print the document for it not to print the shading? Thanks in advance. -- eddie57 ... 22 Mar 2010 11:54

Warning when in another cell after entering a formula.
I find this rather confusing: Cell M7 =IF(SUM(H7:L7)=0,"",SUM(H7:L7)) Cell M8 =IF(COUNTIF(H8:L8,"W")<1,"",COUNTIF(H8:L8,"W")) Cell M9 =IF(SUM(H9:L9)=0,"",SUM(H9:L9)) When I enter the formula in M7 and M8 everything works as expected, however when I enter the formula in M9 I get the diamond with the exc... 20 Mar 2010 22:11

comparing two colums ? countif
Hi, I have a spreadsheet with "weeks in column A and "Daily Charges" in column R. [see below] col A col R Week 1 Week 1 20 Week 1 week 2 week 2 How do I say calculate how many charges [col R] occur in "week 1" i.e. no of times there is a value in "col R" ... 20 Mar 2010 17:46

Variable Labor percentage based off of fixed sales +/-
Excel 2007 Data Table http://www.mediafire.com/file/w2omdzdz2yy/03_20_10.xlsx Pdf preview: http://c0718892.cdn.cloudfiles.rackspacecloud.com/03_20_10.pdf ... 20 Mar 2010 13:13

wildacrds
Hi, XL2003. Is it possible to use wildcards in simple logic statements? If A1 contains "qwerty" and B1 contains "qw" In C1 I've tried: =A1=B1* - xl complained =A1=B1&* -xl complained =A1=B1&"*" - returned FALSE Regards - Dave. ... 20 Mar 2010 12:06

vlookup function returning "na" even though the vlaues are present
i am using a simple vlookup function =vlookup(A13,$B$38..$C$76,2,False) Even though there is correct value for A13 in the array table defined, it is returning "N/A". Can someone tell me what is the problem? ... 20 Mar 2010 06:17

Excel Logical IF function
I am trying to enter in a function in Excel that if is if A5 is less than half of D5, if true Y if false N. I can not figure out how to enter the half of D5 in ... 20 Mar 2010 06:17

formula to a minimum value of zero if a negative number
I need help with a formula: if C1-C2 = a negative number I need it to equal zero and not the negative number. How do I do this? It is probably really simple but I cannot wrap my head around it. Thanks ... 20 Mar 2010 00:35