Thanks for you reply.

In column E there could be those three variables all the way down and
intechangeable eg.

E3 = 8400
E4= 8400/8500
E5-= 8400
E6= 8400/8500/8550
etc etc etc

So my formula now (the one I wrote before), works. But, it only pulls
in 8400. I want it to pull in whatever is in that cell. It doesn't
appear to like 8400/8500 or 8400/8500/8550. If it is either one of the
two variables with a slash it returns 0. when it should theoretically
recall exactly what is in that cell (in the E column).

Is that any clearer?

Cheers