Cell display

[Willy]

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

 

[Lars-Åke Aspelin]

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

 

[Shane Devenshire]

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