Thread: IF (formula is true) put a "1" in another cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Rogers[_2_] Mike Rogers[_2_] is offline
external usenet poster
  
Posts: 284
Default IF (formula is true) put a "1" in another cell
Sandta

Place formula in B1

=if(A1=3000,1 ,"")

Mike Rogers

"Sandta" wrote:

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