formula to copy

  • Thread starter Thread starter Lift Off
  • Start date Start date
L

Lift Off

Maybe I'm missing something, but I'd like to check a cell for a value >
and if it's >0 I'd like to copy the value in the cell to another cel
on the same row.

Sample sheet:
A B C D
1 5 10
2 5 10
3 5 10

In example above I'd like a formula in "C1" that checks "B1" for >0, i
true then copy "B1" to "D1".

TIA, Lift Of
 
I think the closest a formula will come to do is show the content of B1 in
D1 IF(...)

Might try in D1;
=IF(B1>0,B1,"")
 
Thanks guys. I know a maco could do it but tried to stay away from tha
solution.

DaveR: Your solution works but I can't put the formula in "D". Tha
column, "D", I want to keep virgin. Only want to copy to it "from
distance", like from "C" or wherever if the condition is TRUE.

Thanks again, Lift Of
 
Like Ron said, a formula wont actually copy anything..

There are macro 'events' that will copy as you request. I am not up on them
though so I can't be much help there. Check this thread out;

http://tinyurl.com/ys6uc

maybe it'll give you some ideas. Also a google group search for terms like:
excel copy cell if

may help.

Good luck.
 
Back
Top