For example, in G2

=IF(ISNA(G1),G1,"")

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Peterpunkin" wrote in message
...
How would I express the following: " if the cell to the left has N/A in
it,
place N/A in this cell also, otherwise do nothing"
very grateful for your assistance