Not necessarily for ceiling fans or under the bed but I recently came upon a potion to discourage dust from furniture. To me it really works.
mix 2 cups water, 1 tablespoon olive oil, a quarter cup vinegar, a couple drops of Dawn and some
eaaential oil if you want. Shake up and use on furniture. Amazingly I can go over 2 weeks before dust appears on my cherry furniture. I have used it on the polyurethane finished wood floors and it works great. Not sticky, not slippery, doesn't attract dirt. But must wipe right up because of water.