I have set up a sheet for documenting calculations of lengths of skirtiing (for housing). Unfortunately someone has gone in and mad amendments to the original file. I am now attempting to replace the formulas but two things are happening:


1. The same calculation which was originally in the cell (actually it is happening in multiple cells) is not working now- it is coming up with a value error).
2. I had the contents of the cell hidden by selecting "custom" in the number category and typing ;;;.

The formula is: =IF(AK2="MDF",F22*1.075,IF(AK2="Meranti",F22*1.15) )
Where cell AK2 has a drop down option of MDF or Meranti.

As I said, this used to work fine.

Any assistance appreciated,

Mark.