View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Skinman Skinman is offline
external usenet poster
 
Posts: 54
Default Formula to move content from 1 cell to another

In B1 enter this Formula :- =IF(A1<10,A1,"") Put your own value where the
10 is
Skinman


"amn220" wrote in message
...
I need help to write a formula to move information from cell A to cell B
only
if cell A is less than a perticular value.

Thanks
Andy