Answer:
a. =IF(H4>0,12*$D$5-J4,0)
Explanation:
a. =IF(H4>0,12*$D$5-J4,0)
If( H4>0 is the logical test,
12*$D$5-J4 is [value_if_true]
0 is [value_if_false]
b. Referencing to the above formula in (a), which is the required formula which should be typed in cell K4.
Absolute referencing of cell D5 means that this will not change while extending this formula to the entire column. Whereas, since cell H4 and J4 have relative cell referencing, these will change relatively as we extend the formula to the entire column.
For Plato users it's
2. BLOb
