I'm new to functions... How do I write the function "If cell D3 has any
character in it, then cell D4 = 1. If it has no characters, cell D4 = 0"

How about "If cell D3 has the word 'truck' in it, then cell D4 = 1"

Lastly, if I have a column of words such as car, truck, car, bus, bus, can
I somehow total the number of times "car" and "truck" appeared in the column?

Thanks,
Gary