#### Tim4freedom

##### New Member

- Joined
- Mar 3, 2011

- Messages
- 22

When I copy the formula into the cell above this, keeping all criteria exactly the same I get #VALUE! as the result. Even if I Cut, then Paste I get the same outcome, then even more strange, if I then Cut and Paste it back to the original cell below it now gives the correct answer.

The formula is obviously accurate as it gives the correct answer, until it is placed in the cell above.

Can anyone help with this strange situation?

I have manually typed in the same formula and it still gives the #VALUE! outcome!