Filling a cell based on the content of another cell
Hi, thanks for your feedback, I just tested it again and it worked just
fine for me.
If I placed "infant" in "E2", "R2" correctly placed "Daycare"
If I placed "child" in "E3", "R3" correctly placed "Preschool"
If I placed "6" in "E4", "R4" correctly placed "Preschool"
I'm not sure what went wrong for you. You may want to make sure that
the value in the else statement wasn't changed to "infant"
HTH--Lonnie M.
|