Good morning... I am trying to create a custom function but can't seem to get the statment to work.
I am working with four columns: Status; Estimated; Current; Completed. Status is a list box with three possible selections: Completed; In-Progress; Pending. Estimated, Current and Completed are number fields. If the status field reads Completed than the function would insert 100 in the Completed column. If the status field reads anything other than Completed, then the answer in the Completed column should be the result of (Current/Estimated)*100 (to get the percent completion of the task). StatusEstimatedCurrentCompletedCompleted5(should return 100)In-Progress5360 My code looks like: Function Sprint (Status, Estimated, Current, Completed) If Status = "Completed" Then Completed = 100 Else Completed = (Current/Estimated)*100 End If End Function I am beginning to think the issue is using a text comparison to return a number but I haven't come across any documentation that indicates this can't be done. The other issue might be the use of Completed twice even though one is a status determination vice a column name. I did try it with other column names, changing the column name from Completed to Complete, or Completed to Percent, but still couldn't get things to work. Any help would be greatly appreciated. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
