Thread: if statement
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default if statement

In cells I29, I31, D27, D29, D31 enter:

=IF(I27="X","X","")
--
Gary''s Student - gsnu200752


"Karen Smith" wrote:

I'm need to create a formula so if I place an X in Cell I27, X's will be
placed in cells I29, I31, D27, D29, D31. Can anyone help?