The Add texture node adds two textures together. The calculation is similar to the Add layer mode used in Photoshop to add the color values of two layers. Figure 1 shows how the Add texture adds a red color to a Turbulence texture. The result is that the dark parts of the turbulence pattern are tinted red.
Figure 1 : An Add texture is used to tint a turbulence color with a red color.