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.