Formulae

[Guest]

I want the contents of 3 cells to move when i add a number in one of them.
e.g
Permanant info in A1 & C1. When I put a number into B1 I want the info in
A1 B1 & C1 to show in X1 Y1 & Z1.
Is that possible
Many thanks

 

[Guest]

in X1:

=IF(ISNUMBER($B$1),A1,"")

copy across to Y & Z

HTH

 

[JE McGimpsey]

One way:

X1: =IF($B1<>"",A1,"")

Copy to Y1:Z1