Functions

how do i calculate 2' x 4' x 4"
How do I calculate cubic feet in excel? I need to be able to do it two ways. With all feet or with feet and inches. example... 2' x 4' x 3' or 2' x 4' x 1'-5" or 2' x 4' x 4". I have a construction master IV calculator that will give me both answers in cubic feet. 2'x4'x3'= 24cubic feet or 2'x4'x1'-5"=11.33333... 3 Mar 2010 11:51

Formula question
I am trying to complete the following. In s141 i have a drop list with 'yes' and 'no' as possiblities. In x141 i have a drop list with 3 possible choices, .02 , .04 , or .08 g141 is the originating cell p159 is the answer cell. if s141 remains empty or has 'no' chosen from the drop list i need p159 t... 2 Mar 2010 22:38

Total for Cells with same name value
I am sure I've done this before. somehow it alludes me all of a sudden; I have a table with ProductName | Amount Sold Where Product Names can duplicate Sorted by product name I want to run a simple column formula so it will step down and as long as it is still in same product group (i.e. A6=A5) it will... 2 Mar 2010 21:31

Some cells or styles in this workbook contain formatting that is
Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest format available. ... 2 Mar 2010 21:31

How to count number of sheets
How to put the total number of sheets in a work cell? Thanks ... 2 Mar 2010 21:31

Timecard functions and formulas
I have made a timecard with excel everything is working as planned except for one thing. I am unable to get the roper formula or function to calculate my pay. I am not concernned with overtime being calculated just straight time. I have 2 pay rates $27 per hour for scanning and $10 per hour for drive time. When ... 2 Mar 2010 20:24

Formula Help - ce
I have a report which contains the following data (sample below) S_Name Day Month Year Trans_Amount Date Time North 2 3 2010 236 2/28/10 2:00 PM 2:00pm Using the example above I need a formula that looks at this source sheet and sums the transaction amount... 2 Mar 2010 16:58

Inserting graphics on excel chart is not visible
Got a chart that I inserted graphics on but when doing a print preview, it does not show nor does it print when using excel ver 2003. Home network it to my win7 machine office 2007 and it shows as expected. Tried the options of selecting the graphic and bringing it to front etc. does not work in excel 03. (... 2 Mar 2010 15:50

Conditional Formatting - Inserting Rows
Hi, Is there a way that when you insert rows, the conditional formatting on the adjacent rows does not copy into the inserted/new row? Thanks, ... 2 Mar 2010 16:58

concatenate
I am trying t convert 2 cells, but i only want to merge if the total characters does not exceed 70 characters, can anyone help me with a formula for that? ... 2 Mar 2010 15:50