No announcements
Found 2423815 threads
-
4 VotesHow do I avoid #Error results in Microsoft Project Formulas
The #Error just needs to be found through testing - although, often hitting F9 to refresh the calculations will resolve it.Answered | 6 Replies | 27855 Views | Created by Skerpie - Sunday, March 3, 2013 10:29 PM | Last reply by Paulo Krespo - Sunday, November 10, 2019 2:32 PM
-
0 Votes
Project - formula result not shown
Actually, I recreated a fresh project file yesterday and ... it works.Answered | 14 Replies | 1498 Views | Created by fibag21 - Wednesday, December 11, 2013 1:29 PM | Last reply by Guillaume Rouyre [MBA, MVP, MCC] - Tuesday, January 7, 2014 4:38 PM -
0 Votes
Avoiding "Divided By Zero" error in the formula
Just to clarify, there is nothing built into TSQL to avoid divide by 0.Answered | 4 Replies | 917 Views | Created by Sid Williams - Monday, February 15, 2016 11:37 AM | Last reply by Tom Phillips - Monday, February 15, 2016 1:21 PM -
1 Votes
creating "IF" boolean logic formula in microsoft project custom field.
and does this create a lacuna or shortfall in Microsoft project which could be addressed in later versions?Answered | 13 Replies | 34880 Views | Created by ayo arimoro - Saturday, April 2, 2011 9:16 PM | Last reply by John - Project - Tuesday, December 18, 2018 5:02 PM -
4 Votes
PWA 2010 Project Center View - Formula error
After doing this, the custom field should show the desired result in PWA.Answered | 14 Replies | 15138 Views | Created by Naomi Flanagan, PMP, MCTS - Monday, October 4, 2010 4:15 PM | Last reply by Dale Howard [MVP] - Monday, February 14, 2011 10:16 PM -
0 Votes
Updating the date in project Center not affecting the formula
Hi Benno, Glad that its sorted for you - i think you some how overlooked my response, where i have mentioned to press F9 to calculate ...Answered | 9 Replies | 9208 Views | Created by Benno EPM - Tuesday, March 22, 2011 9:48 AM | Last reply by Benno EPM - Wednesday, March 23, 2011 10:38 AM -
0 Votes
FILTERXML removes punctuation from values - how do I avoid this?
I had another user on another forum tell me that the formulas worked just fine, and I knew that separators etc were derived from the system settings... hopefully ...Answered | 3 Replies | 784 Views | Created by Christopher Aaby - Friday, January 27, 2017 9:12 AM | Last reply by Christopher Aaby - Monday, February 6, 2017 11:30 AM -
0 Votes
How do I bold text with a formula (Excel 2007)
You may be right, we may be able to avoid the PasteSpecialValues.Answered | 4 Replies | 23206 Views | Created by BJNewman - Tuesday, January 4, 2011 7:00 PM | Last reply by Gary's Student MVP - Thursday, January 6, 2011 12:12 AM -
2 Votes
Project server 2007 formula
thanks, Iwant also to get the querter number and year, how will it work?Answered | 6 Replies | 9610 Views | Created by elaine lance - Wednesday, June 15, 2011 11:41 AM | Last reply by Dale Howard [MVP] - Thursday, June 23, 2011 2:18 PM -
2 Votes
How do I use Task and Group Summary row fields in a formula ?
For a combination of syntax and the most important objects I would recommend Rod Gill's book VBA programming for Microsoft Office ...Answered | 9 Replies | 10959 Views | Created by DDNProcess - Tuesday, November 16, 2010 10:24 PM | Last reply by Jan De Messemaeker - Project MVP - Wednesday, November 17, 2010 8:11 PM -
0 Votes
Result of Formula it's incorrect
Yes when i exported to Visio i only need to change the format and it is ok!Answered | 5 Replies | 4858 Views | Created by Daniel Bustamante - Wednesday, June 22, 2011 4:54 PM | Last reply by Daniel Bustamante - Wednesday, June 22, 2011 8:30 PM -
0 Votes
Inconsistent formula results
http://www.excelforum.com/excel-worksheet-functions/614583-inconsistent-formula-error.htmlAnswered | 3 Replies | 5053 Views | Created by MPettijohn - Friday, April 27, 2012 7:05 AM | Last reply by nanurahi - Wednesday, May 2, 2012 9:51 AM -
0 Votes
How do i record output of a formula at a given time into another cell ?
The macro could copy the formula cell and paste its value into another cell.Answered | 1 Replies | 1206 Views | Created by ewmclean - Sunday, August 18, 2013 12:52 PM | Last reply by Gary's Student MVP - Sunday, August 18, 2013 8:51 PM -
0 Votes
Avoid errors in Computed Columns
declare @t table (i decimal(3,2) primary key, j decimal(3,2), k as i/j); insert @t(i,j) values (1,2); insert @t(i,j) values ...Answered | 3 Replies | 1425 Views | Created by Sid Williams - Monday, October 17, 2016 5:07 PM | Last reply by Tom Phillips - Monday, October 17, 2016 6:39 PM -
0 Votes
How do I use 'constants' and 'IF' formulas in Excel?
Hi, As your problem is related to Excel 2011 for MAC and we have no Office 2011 for MAC environment, I suggest you post your issue to Excel 2011 for MAC ...Answered | 1 Replies | 503 Views | Created by How to use 'constants' and 'IF' formulas in Excel - Monday, June 27, 2016 8:47 PM | Last reply by Emi Zhang - Tuesday, June 28, 2016 8:00 AM -
1 Votes
How can I convert Architect Formula into Excel?
I will mark if is the correct formula.Answered | 7 Replies | 996 Views | Created by GC2006 - Monday, April 2, 2018 6:59 AM | Last reply by GC2006 - Tuesday, April 3, 2018 9:27 AM -
2 Votes
How do I use macros and excel formulas in a Power Query spreadsheet?
Keep manual calculations and create a macro to do your data refresh.Answered | 2 Replies | 1544 Views | Created by Lord Graystoke - Thursday, July 2, 2015 9:07 PM | Last reply by Greg Deckler (Fusion Alliance) - Saturday, July 4, 2015 1:04 PM -
0 Votes
How to display a custom formula field
Build your formula using the read only plan to verify that that you can get the result you desire.Answered | 3 Replies | 2282 Views | Created by jababda - Wednesday, January 21, 2015 8:49 AM | Last reply by Gary Chefetz, MCITP, MCT, MVP - Thursday, January 22, 2015 9:49 AM -
3 Votes
Calculated field formula results in syntax error when using Dutch(Belgium)
Hi Brecht, I also always use Dutch(Belgium).Answered | 1 Replies | 5866 Views | Created by Brecht DB - Wednesday, April 10, 2013 7:38 AM | Last reply by endeka - Wednesday, April 10, 2013 8:45 AM -
0 Votes
Microsoft Excel 2013 formula help
In I2, enter the formula =RANK.EQ(H2,$H$2:$H$50) Fill or copy down from I2 to I50.Answered | 1 Replies | 763 Views | Created by Sazulfi - Sunday, November 22, 2015 7:34 AM | Last reply by Hans Vogelaar MVP - Sunday, November 22, 2015 1:08 PM - Items 1 to 20 of 2423815 Next ›
No announcements
