"What is the difference between the "UP" and "OFF" positions?"
Up - the gear is hydraulically powered up
Off - as 'Billyt" says; the gear is held up by the mechanical uplocks because the gear hydraulics are shut off. In the event of turbulence the gear handle is selected back to UP to provide hydraulic up pressure to reduce structural loads on the mechanical uplocks.