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.

  • YES would then ask "Is Waterproof Reqd?". The reply to that question returns either the area or a value of zero.
  • NO would do nothing further.