Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to copy a cell with an if-function?
Hi
In a if-function, i can do the whole value if true and false etc. but now i would like to copy the value of the true cell into the cell where the if function is. for instance, if this cell is 0, then it must take the newe value of the logical test. then the cell value would be 5345. if its 232, then the if function is false, and nothing is suppose to happen. i can click and drag the whole time, but in a spreadsheet of thousands human error is very likely to happen. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to copy a cell with an if-function?
hi,
it would have been helpful if you had posted your formula. formulas return values. they cannot perform actions like copy and paste. without seeing your formula, i can only suggest that your restructure your formula to return the appropreate value sorry Regards FSt1 "Mariusjjoubert" wrote: Hi In a if-function, i can do the whole value if true and false etc. but now i would like to copy the value of the true cell into the cell where the if function is. for instance, if this cell is 0, then it must take the newe value of the logical test. then the cell value would be 5345. if its 232, then the if function is false, and nothing is suppose to happen. i can click and drag the whole time, but in a spreadsheet of thousands human error is very likely to happen. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to copy a cell with an if-function?
You may want to do like this:
=IF(A71234,A7,FALSE) This formula takes the value of the tested cell, if condition is true, if not, it returns FALSE (boolean) When you are done, select all cells which contain the IF-Formula (i.e. a whole column). Press F5 (GOTO), select Special.... In the Select Options, choose "Formula" and only keep "Numbers". Confirm by clicking OK Now only the cells where condition evaluated to TRUE (the number) are still selected. Hit Edit-Copy, Edit-Paste Special... Choose "Values" and confirm. You are done ! "FSt1" wrote: hi, it would have been helpful if you had posted your formula. formulas return values. they cannot perform actions like copy and paste. without seeing your formula, i can only suggest that your restructure your formula to return the appropreate value sorry Regards FSt1 "Mariusjjoubert" wrote: Hi In a if-function, i can do the whole value if true and false etc. but now i would like to copy the value of the true cell into the cell where the if function is. for instance, if this cell is 0, then it must take the newe value of the logical test. then the cell value would be 5345. if its 232, then the if function is false, and nothing is suppose to happen. i can click and drag the whole time, but in a spreadsheet of thousands human error is very likely to happen. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List of functions contained in the add-ins, esp. Analysis Toolpak | Excel Worksheet Functions | |||
VBA: For Count, when count changes from cell to cell | Excel Discussion (Misc queries) | |||
Cell References | Excel Discussion (Misc queries) | |||
disabling the copy paste function in a cell | Excel Worksheet Functions | |||
hpw do I logic test a cell then copy the row to diff. SS | Excel Worksheet Functions |