#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
The formula seems correct. Perhaps post a sample sheet ( click Go advanced - Manage attachments)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Thanks Pecoflier, for some reason it has now decided to work today. Not knowing why it is working is almost as frustrating as not knowing why it didn't! I am not aware of any changes I have made.
Cheers, Mark |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula works on most cells | gbaker | Excel | 1 | 04-26-2014 12:31 AM |
Microsoft Word 2010 Starter no longer works | Lili | Word | 1 | 09-15-2013 11:04 PM |
2007 office key no longer works | millertime | Office | 6 | 02-19-2012 07:50 PM |
mouse no longer works inside word documents? | trob | Word | 0 | 02-01-2012 11:36 AM |
Ctrl+Home no longer works to get me to beginning of doc. | migdaw01 | Word | 0 | 01-13-2011 12:11 PM |