I'm trying to get the 30000 figure in cell b39 to disappear so that the cell and all following cells in the b column are blank when there is no corresponding figure in column A . I have reproduced the functions that appear under colmn a and b. the column a formula works. HOever there is something wrong with the column be formula. it isn't stopping the 30000 figure from appearing. Is the problem using "" as the false reference in the IF function.
A B
36 2015 30000
37 2016 30000
38 2017 30000
39 30000
=IF(A32<$G$7, A32+1, "") =IF(A36>1,$G$10, "")
=IF(A36<$G$7, A36+1,"") =IF(A37>1,$G$10, "")
=IF(A37<$G$7, A37+1,"") =IF(A38>1,$G$10, "")
=IF(A38<$G$7, A38+1,"") =IF(A39>1,$G$10, "")
=IF(A39<$G$7, A39+1,"") =IF(A40>1,$G$10, "")
=IF(A40<$G$7, A40+1,"") =IF(A41>1,$G$10, "")
=IF(A41<$G$7, A41+1,"") =IF(A42>1,$G$10, "")
sorry, but this isn't displaying correctly.
Bookmarks