ExcelBanter - Formulae

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formulae (https://www.excelbanter.com/excel-worksheet-functions/142184-formulae.html)

againstallodds1606

Formulae

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

Toppers

Formulae

in X1:

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

copy across to Y & Z

HTH

"againstallodds1606" wrote:

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

JE McGimpsey

Formulae

One way:

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

Copy to Y1:Z1

In article ,
againstallodds1606
wrote:

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

All times are GMT +1. The time now is 12:55 PM.