Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-04-2015, 02:55 PM
piper7971 piper7971 is offline formula in excel 2007 works not in 2013 Windows Vista formula in excel 2007 works not in 2013 Office 2007
Advanced Beginner
formula in excel 2007 works not in 2013
 
Join Date: Jul 2010
Posts: 38
piper7971 is on a distinguished road
Default formula in excel 2007 works not in 2013

Hi!
I am using this formula in a worksheet I created in excel 2007 but when someone open the worksheet using excel 2010 or 2013 it doesn't work it change all the numbers to #. Any ideas why?



=IF(M8="","",IF(WEEKDAY(M8)=2,"L",IF(WEEKDAY(M8)=3 ,"K",IF(WEEKDAY(M8)=4,"M",IF(WEEKDAY(M8)=5,"J",IF( WEEKDAY(M8)=6,"V",""))))))

this is for a calendar.

thanks!
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
formula in excel 2007 works not in 2013 Formula works on most cells gbaker Excel 1 04-26-2014 12:31 AM
Excel 2007 - formula or macro/vba code required wrighty50 Excel Programming 3 05-13-2012 02:24 PM
2007 office key no longer works millertime Office 6 02-19-2012 07:50 PM
Is there a graphic tutorial available on how the Word 2007 ruler works? Jenjen80 Word 0 07-13-2010 07:41 PM
Works 9 Upgrade to Office 2007 Standard TXJAWA Office 0 05-03-2010 07:49 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:08 AM.


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