Yes, but it depends where you live. It's easy to get around the main areas of Funchal on foot. However, if you live anywhere outside of Funchal, you'll probably need a car, as public transport on wider Madeira can be sparse and unpredictable. Also, having a car opens up the island and enables you to reach interesting places inaccessible by public transport.