Is there a Point and Shoot camera with a Macro function or ability?

Question

I am looking for a simple point and shoot camera with a macro function to be able to take photographs for eBay auctions.

Are there any P&S cameras with this function?

Answer

There are plenty. What I recommend though is a compact with manual controls and for the purpose of eBay, unless you are selling truly miniature items such as insects, they are more recommended than DSLRs and SLDs.

A number of ultra-zooms are actually capable of extremely close focusing distance, as close as 0cm even! Although you will have lighting problems if you get that close, any of those models will do to focus closely. Not only that, the depth-of-field will be much greater than with an interchangeable lens, which is less artistic but arguably better for selling products.

The Canon Powershot SX150 (1cm min) or older SX200 (0cm min) are great choice in a compact form-factor. You can also go with an ultra-zoom like the Canon SX40 or Fuji HS20 EXR. Since these cameras have manual controls, you can set the aperture very small to capture an large depth-of-field. Just make sure to keep the ISO low for getting quality output and using a tripod for stability.

Check more discussion of this question.