Thread: Formula question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pablo bellissimo pablo bellissimo is offline
external usenet poster
  
Posts: 27
Default Formula question
in A2 type
=if(A1="30907",".14","")

That should do it...



"GKW in GA" wrote:

I cell A1 contains 30907, I want A2 to be .14 otherwise I wnat A2 to be
blank. How do I do this
Reply With QuoteReply With Quote