| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Move
I have the need to copy the content of a cell to another cell based on the
value of a totally different cell. If A1 is =1 and =<10, then I need to copy the content of a3 to a4. Any clues on how to get this to work? Thanks, Mike |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Move
Formulae can't copy data from one cell to another, they can only return
values to their calling cells, so one way: Put this in A4: =IF(ABS(A1-5)<=5, A3, "") In article , Mike wrote: I have the need to copy the content of a cell to another cell based on the value of a totally different cell. If A1 is =1 and =<10, then I need to copy the content of a3 to a4. Any clues on how to get this to work? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Move
In A4, use the formula =IF(AND(A1=1,A1<=10),A3,"whatever you want in A4 if
your condition isn't satisfied") -- David Biddulph "Mike" wrote in message ... I have the need to copy the content of a cell to another cell based on the value of a totally different cell. If A1 is =1 and =<10, then I need to copy the content of a3 to a4. Any clues on how to get this to work? Thanks, Mike |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Move
If you go down that route, oughtn't it to be =IF(ABS(A1-5.5)<=4.5, A3, "") ?
-- David Biddulph "JE McGimpsey" wrote in message ... Formulae can't copy data from one cell to another, they can only return values to their calling cells, so one way: Put this in A4: =IF(ABS(A1-5)<=5, A3, "") In article , Mike wrote: I have the need to copy the content of a cell to another cell based on the value of a totally different cell. If A1 is =1 and =<10, then I need to copy the content of a3 to a4. Any clues on how to get this to work? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Move
You're right- I was thinking 0 to 10, not 1 to 10.
Thanks for the correction. In article , "David Biddulph" <groups [at] biddulph.org.uk wrote: If you go down that route, oughtn't it to be =IF(ABS(A1-5.5)<=4.5, A3, "") ? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Move
Thanks everyone for your help, it is working great.
Mike "Mike" wrote: I have the need to copy the content of a cell to another cell based on the value of a totally different cell. If A1 is =1 and =<10, then I need to copy the content of a3 to a4. Any clues on how to get this to work? Thanks, Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel-how to get the spreadsheet to move as I move the scroll tab | Excel Discussion (Misc queries) | |||
| How do I stop making the spreadsht move when I move up/dwn/lt/rt? | Excel Worksheet Functions | |||
| Move merged cells with conditional formatting? | Excel Worksheet Functions | |||
| When I move scroll bar in excell the contents do not move with it | Excel Discussion (Misc queries) | |||
| can I move data from workbook A to B using a conditional formula | Excel Worksheet Functions | |||
Linear Mode
