View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mariusjjoubert Mariusjjoubert is offline
external usenet poster
 
Posts: 1
Default 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.