Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-20-2017, 03:20 PM
Silkwood Silkwood is offline Help with a formula which no longer works. Windows 7 64bit Help with a formula which no longer works. Office 2013
Novice
Help with a formula which no longer works.
 
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 Help with a formula which no longer works. Windows 7 64bit Help with a formula which no longer works. Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 03-21-2017, 02:25 PM
Silkwood Silkwood is offline Help with a formula which no longer works. Windows 7 64bit Help with a formula which no longer works. Office 2013
Novice
Help with a formula which no longer works.
 
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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with a formula which no longer works. 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:13 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft