Hi,
I have two calculation rows (we will call them rows 1 and 2) that are dependent on another row (row 3) having a value.
When row 3 has a value both rows 1 and 2 should show. However, when row 3 does not have a value, the row is suppressed and row 2 should also be suppressed. Does anyone know what formula would achieve this?