Example: Suppose you set up the following double IF statement:

IF( Is Fill Insul Reqd ? ,IF( Is Waterproof Reqd ? ,Area SF,0),0)

The answer to "Is Fill Insul Reqd?" determines what happens next.