Any other conditions?

Try this in I29:

=IF($I$27="X","X","")

then copy it to the other cells.

Hope this helps.

Pete

On Oct 30, 1:43 pm, 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?