formula in excel 2007 works not in 2013

		Microsoft Office Forums > Microsoft Excel > Excel
formula in excel 2007 works not in 2013

FAQ

Thread Tools

Display Modes

07-04-2015, 02:55 PM

piper7971

Windows Vista formula in excel 2007 works not in 2013

Office 2007

Advanced Beginner

Join Date: Jul 2010

Posts: 38

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!

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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 12:18 PM.