I have a chart with months on X axis
On the Y axis are monthly values which are generated by a formula.
I want to insert the formula for the whole year but truncate the chart at the latest month. i.e. At end of July the chart should only show values to end July but the formula would extend to...
I have a simple formula which sometimes produces a #DIV/0! when the divisor is zero.
I wanted to just show 0 or even -.
I tried this =IF(+D10/E10>0,D10/E10,0) but it still gave me #DIV/0!.
I am sure the answer is simple but I cannot think of it.
Stephen Argles
Land & Marine...
The autoshape default line widths, colours, and fill options are no use to me. I have to change them every time I create a new drawing. Is there a way of changing the default properties?
Stephen Argles
Land & Marine
www.landandmarine.com
Is there a way to format a cell to read 6" instead of 6in (as in Custom format #"in")? #" " " does not work?
Stephen Argles
Land & Marine
www.landandmarine.com
I have a series of formula in a row and I want to produce the same in a column on another worksheet.
I thought that thread770-25863 (which uses Notepad)would help but it does not as it increments the Row Number.
Copy, Paste special, Transpose only works on data not formula.
Any solutions?
In analised the severity of a risk we look at Injury, Programme, Cost,and Likelyhood.
Each is given a 1 to 5 value (1 is very low, 5 is very high).
We add the (Injury + Programme + Cost) and multiply by the Likelyhood to arrive at a Severity figure. The risks are then tabulated to give highest...
We have a pipeline with a thick layer of limescale (up to 15mm). Some of it can be scrapped off but we are thinking to use Citric acid to clean the bends, delivered between a pair of pigs.
The question is how much acid do we need and how long do we leave it in place?
StephenA
I have been using the Custom format for several years such as entering 2 in the cell and reading 2 kg/m3.
In text only format you can wrap text, or use Ctrl Enter to add a line in a text only cell.
Is there a way to wrap the text in a custom cell where the description is too long for the cell...
Does anyone have information on correlation between SPT, CPT and DP test results in granular soils.
I am only looking for a coarse relationship at this stage.
Best regards
StephenA
I put this question in a different forum and got no replies, This forum looks more appropriate. Apologies if duplication annoys anyone.
We have designed an outfall with pumps well above sea level. When the pumps stop the sewage level drops to sea level. That cannot be changed.
Normally the...
We have designed an outfall with pumps well above sea level. When the pumps stop the sewage level drops to sea level. That cannot be changed.
Normally the pumps would be started slowly to allow the air to back up and release through an air valve close to the pumps.
The client wants to start...
