Thread: IF (formula is true) put a "1" in another cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sandta Sandta is offline
external usenet poster
  
Posts: 1
Default IF (formula is true) put a "1" in another cell
How do you put a value in another cell if the formula you are using is true.

=if(A1=3000,"(put a 1 in B1)",otherwise false)
Reply With QuoteReply With Quote