Thread: how do i enter a copy of a cell into another cell If 0
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default how do i enter a copy of a cell into another cell If 0
Not sure if you mean "Copy"
This formula in B1 will display the value from A1 if C1 1
=IF(C11,A1,"")
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"fleety" wrote in message
...
how do u copy cell A to cell B if cell C is 1


Reply With QuoteReply With Quote