Chapter 7 - Spreadsheets: Relational & Boolean Operators

The formula needed in cell D5 is =IF(B5,B1,0). The value needed for the logical_test changes relatively (B4 to B5). However, the benefit amount remains $300 (as given in cell B1), so this reference should have an absolute row. The value if there is no benefit is just the constant $0, which does not change. The final formula is: = ................
................

In order to avoid copyright disputes, this page is only a partial summary.