Display 0 when cell contains certain letters

[barbara58554]

I'm working on an attendance form that has columns showing P, T, W, etc that indicate if the child was in school or why the child was absent. A couple columns over are 3 columns showing if the child was served breakfast, lunch and/or snack. I want the days the child was gone to automatically fill with a 0 in the breakfast, lunch, snack columns. I have been trying to figure this out most of the day and finally seek your assistance.

Hope this visual helps:

M

T

W

T

CHILD'S NAME

BREAKFAST

LUNCH

SNACK

B

L

S

B

L

S

B

L

S

A

P

P

P

I want this column to display 0 if A, T, OR W is in 1st column

I want this column to display 0 if A, T, OR W is in 1st column

I want this column to display 0 if A, T, OR W​ is in 1st column​

I want this column to display 0 if A, T, OR W is in 2ND column​

I want this column to display 0 if A, T, OR W is in 2ND column​

I want this column to display 0 if A, T, OR W is in 2ND column​

I want this column to display 0 if A, T, OR W is in 3RD column​

I want this column to display 0 if A, T, OR W is in 3RD column​

I want this column to display 0 if A, T, OR W is in 3RD column​

I want this column to display 0 if A, T, OR W is in 4TH column​

I want this column to display 0 if A, T, OR W is in 4TH column​

I want this column to display 0 if A, T, OR W is in 4TH column​

<tbody> </tbody>

 

[barbara58554]

Dave,

It's Monday morning and I was so excited when I saw the response to my question. I feel like doing the victory dance around my office! This worked exactly the way I wanted. Thanks so much.

Don't suppose you have a formula to stop the snow from falling for a while in North Dakota?!?!? We have had almost 30 inches of snow in the last couple weeks!

Barbara

 

[SQUIDD]

Hi Barbara.

Im glad it worked for you.
I guess this will help things run easier at school

enjoy the snow.

Dave.