Can anyone tell me the best way to write an Excel function which determines whether the Best Lay Price (H5 say) is no further away from the Best Back Price (F5 say) than 5 TICKS....
For example IF(H5-F5 < 5 Ticks,..........)
Hopefully you'll see what I need.....
PS, I have a module which includes Gary's uptick and downtick code but this places a value in the R column which I need for a different price so I can't use this value as it stands unless I can shift Gary's values to another column....if you see what I mean