Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |