View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default How to display a value in say B2 in B3 IF a value in B1 is true

in B3 put

=IF(B1=TRUE,B2,"")



lespal wrote:

I want to copy a value cell B2 into cell B3 IF a value in B1 is true.