Ah..thank you so much :) Now I can quit pulling my hair out :)
Terese On Monday, December 8, 2014 9:16:04 AM UTC-5, Vabz wrote: > > You can do with simple formula... > > Check this... > > +++++ > *I did not do this for you. God is here working through me for you.* > > On Mon, Dec 8, 2014 at 6:59 PM, tlkng1 <tl...@verizon.net <javascript:>> > wrote: > >> 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-Progress53 >> 60 >> >> >> 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...@googlegroups.com <javascript:>. >> To post to this group, send email to excel-...@googlegroups.com >> <javascript:>. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- 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.
