| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formulae | New Users to Excel | |||
| age formulae | Excel Discussion (Misc queries) | |||
| 3D formulae | Excel Discussion (Misc queries) | |||
| Formulae | Excel Worksheet Functions | |||
| Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions | |||
Linear Mode
