Cell display
 

Due to a print formatting issue I am trying to copy the contents of one cell
to another. If the original cell is blank, I want the duplicate cell to be
blank. If the original cell contains a numeric value, I want the duplicate
cell to contain the numeric value to two decimal places. How do I format the
duplicate cell to achieve this?

Thanks

Cell display
 

On Sat, 27 Dec 2008 16:42:00 -0800, Willy
wrote:

Due to a print formatting issue I am trying to copy the contents of one cell
to another. If the original cell is blank, I want the duplicate cell to be
blank. If the original cell contains a numeric value, I want the duplicate
cell to contain the numeric value to two decimal places. How do I format the
duplicate cell to achieve this?

Thanks

If A1 is the original cell, try the following formula in the duplicate
cell:

=IF(A1="","",A1)

Format the duplicate cell as number with two decimals.

Hope this helps / Lars-Åke

Cell display
 

Hi,

=IF(A1,A1,"")

Assuming the cell you want to test is A1 then in another cell enter the
formula above. Note the cell is not really blank, it contains a formula
which displays as blank.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Willy" wrote in message
...
Due to a print formatting issue I am trying to copy the contents of one
cell
to another. If the original cell is blank, I want the duplicate cell to
be
blank. If the original cell contains a numeric value, I want the
duplicate
cell to contain the numeric value to two decimal places. How do I format
the
duplicate cell to achieve this?

Thanks