Cell formatting

[FatBob]

For print formatting purposes I need to duplicate a keyed in numeric value
from one cell (say A4) into another cell (say Z4). In many cases the
original cell (A4) will be blank. How do I make the duplicate cell (Z4)
remain blank also? Right now I end up with the original cell (A4) as blank
and the duplicate cell (Z4) as a 0 value. If I do put an entry into the
original cell, it will be numeric (say 1.3). The duplicate cell will have
the same number of significant digits as the original cell.

 

[Lars-Åke Aspelin]

For print formatting purposes I need to duplicate a keyed in numeric value
from one cell (say A4) into another cell (say Z4). In many cases the
original cell (A4) will be blank. How do I make the duplicate cell (Z4)
remain blank also? Right now I end up with the original cell (A4) as blank
and the duplicate cell (Z4) as a 0 value. If I do put an entry into the
original cell, it will be numeric (say 1.3). The duplicate cell will have
the same number of significant digits as the original cell.

Try this formula in cell Z4:

=IF(A4="","",A4)

Hope this helps / Lars-Åke

 

[Shane Devenshire]

Hi,

In cell Z4 enter the formula

=IF(A4,A4,"")

If this helps, please click the Yes button.

Cheers,
Shane Devenshire