It depends on what you're doing. Most of the time, the fans are totally inaudible. Even at full bore, it's an unobtrusive "woosh" not an annoying "whine." And Apple probably has the best fan control in the business in terms of not fluctuating between different speed ranges. It's actually kind of a shock to go back to a ThinkPad and hear the fan struggling.
