How to copy a cell with an if-function?

[Mariusjjoubert]

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.

 

[FSt1]

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

 

[Quinoman Michael (Germany)]

You may want to do like this:
=IF(A7>1234,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 !