ExcelBanter - Excel 2003 "If" function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel 2003 "If" function (https://www.excelbanter.com/excel-worksheet-functions/447781-excel-2003-if-function.html)

Kalop

Excel 2003 "If" function

This function - IF(C10=$BX$5,$BO$4,"")....... is written in cells BX10:BX500.......
and work correctly in single row, but every time the new row start, for sample: .....IF(C11=$BX$5,$BO$4,"")
data in previous cell BX in that case BX10 disappear.

It is possible to create formula that prevent that??

Please help

All times are GMT +1. The time now is 01:55 PM.