I have the following code taken from some fantastic stuff from richie previously
I have been able to use the code before for all sorts but am having trouble on swapping the above for an if statement that enters the following (in vba).
if ((R[-1]C[-7] - R[-1]C[-8])=between 60 and 75,0.3, if between 150 and 180, 0.66, if between 250 and 365, 1, otherwise 0.5
I tried finding 'between' on help but it was nowhere to be found? :?
Any help much appreciated once more!