Thank you

I have now done as mentioned and the cell is now saying #value!

sorry to be a pain a thank you again for assissting me:)