Something else some may find useful is I like to remove all the detail in BSP and revert it back to valid ticks ...=if(and(CellAddress>1,CellAddress<=1000),if(CellAddress<2,Round(CellAddress,2),if(CellAddress<3,Round((CellAddress)*50,0)/50,if(CellAddress<4,Round((CellAddress)*20,0)/20,if(CellAddress<6,Round((CellAddress)*10,0)/10,if(CellAddress<10,Round((CellAddress)*5,0)/5,if(CellAddress<20,Round((CellAddress)*2,0)/2,if(CellAddress<30,Round((CellAddress),0),if(CellAddress<50,Round((CellAddress)/2,0)*2,if(CellAddress<100,Round((CellAddress)/5,0)*5,if(CellAddress<=1000,Round((CellAddress)/10,0)*10,1000)))))))))),"ERROR")
You can include the actual "Cell Address" using Excel's Replace facility and having done it once any copying of the formula cell will change the target cell relatively.