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.