Help with a formula which no longer works.
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.
|