Thread: moving results to new column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default moving results to new column

In B1

=IF(A2=1,A1,"") will set B1=A1 if A2=1 else B1 will be empty ("")

"grumpybbear" wrote:


i have a result of a formula in cell 'A1'. what i need now is to be able
to move that result to say 'B1' if 'A2'='1'


--
grumpybbear
------------------------------------------------------------------------
grumpybbear's Profile: http://www.excelforum.com/member.php...o&userid=37446
View this thread: http://www.excelforum.com/showthread...hreadid=571121


Reply With QuoteReply With Quote