Well, generally speaking, the closer they are, the more rangebound the market will be. Although it also means if the market breaks the furthest support or resistance, it may be in for a nice run.
When two pivots are relatively close together (ie. R1 & R2), they usually provide a substantial barrier. (Throw up a chart of the QQQQ today with Woodie's Pivots, you'll see what I mean).