Cell Formatting affecting formulas

Hi All,

I can't post an example as the file is too big, but when I use formulas on cells that are already extracting data from other pages, the formulas don't work. But if I was to just type up an example and then apply the formula, it works.

Is there anything I can do to amend this?

OK, I've done a bit of deleting.

Let me explain...

Page 'Intouch' is drawing data from our system via Access, as is 'Box Details'

On page 'Machine 1'I have the following formula in AE2:

=IF(AND(AC2>=$B$9,AD2>=$F$9,AC2<=$K$9,AD2<=$L$9),$I$9,0)

If I was to type up the data it is looking at then apply the formula it works. But because it's extracting data from certain pages it's returning a 0 value, when, in this instance, it should be returning 2.

I've looked at the formatting of the cells but I can't see where a problem may lie.

So simple!

Thank you very much, appreciate it

Sorry to be a pain,

=IF(AND(AB2>=$B$9,AC2>=$F$9,AB2<=$J$9,AC2<=$K$9),$I$9,0) If I alter this formula to

=IF(AND(AB2>=$B$10,AC2>=$F$10,AB2<=$J$10,AC2<=$K$10),$I$10,0) it's suddenly not picking up any data.

What have I done wrong!!

Sorry...

Ok, I've kinda started from scratch on this.

I've reattached what I'm doing. For some reason I'm not getting an results. As far as I can see I've amended the dates that are showing as text so that the formula should work, however on 'Machine 1' in column L and O there are no results showing and I can't fathom why...