Cell display

  • Thread starter Thread starter Willy
  • Start date Start date
W

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
 
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
Click to expand...

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
 
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
 
Back
Top