Hi Bill

in cell R2
=IF(E2="infant","Daycare","preschool")
this can then be filled down column R

however, please note, if there is nothing in E2 you will still get
"preschool" - so the following formula might be better
=IF(E2="","",IF(E2="infant","Daycare","preschool") )

Regards
JuileD


"Bill" wrote in message
...
I am trying to fill the column starting at R2 going down based on the data
contained in cell E2 going down. I want something like an If statement ot
fill the cells going down based the R column starting at R2. If the value
in
E2 says infant then I would need R2 filled with Daycare otherwise the cell
would need to be filled with preschool.