Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-20-2017, 03:20 PM
Silkwood Silkwood is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Mar 2017
Posts: 2
Silkwood is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 03-21-2017, 01:41 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 1,901
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice
Default

The formula seems correct. Perhaps post a sample sheet ( click Go advanced - Manage attachments)
Reply With Quote
  #3  
Old 03-21-2017, 02:25 PM
Silkwood Silkwood is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Mar 2017
Posts: 2
Silkwood is on a distinguished road
Default

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
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 09:56 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft