owenmyers27 Perhaps best demonstrated in a working example. See attached. I kept the "helper cells" in it, so that you can see the steps needed to come to the end result. Hope you think it's helpful.
Hello all,
I'm trying to convert a column of number ranges (formatted 0-10, 10-25) into the value of the range (10-25 = 15 etc.) Can anybody help me with a function to do this?
Additionally and even more helpful would be a function that can convert this number range column which is in cm (0-10) to a number range in inches (0-10 cm 0-3.937 in). If somebody can help me do one of these things it would save me buckets of time.
Best regards,
Owen
","kudosSumWeight":0,"postTime":"2021-03-18T14:55:15.936-07:00","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"tags":{"__typename":"TagConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"TagEdge","cursor":"MjUuMXwyLjF8b3wxMHxfTlZffDE","node":{"__typename":"Tag","id":"tag:excel","text":"excel","time":"2016-06-21T14:08:51.129-07:00","lastActivityTime":null,"messagesCount":null,"followersCount":null}}]},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:2221216_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":4983},"visibilityScope":"PUBLIC","canonicalUrl":null,"seoTitle":null,"seoDescription":null,"isEscalated":null,"placeholder":false,"originalMessageForPlaceholder":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}},"archivalData":null,"customFields":[],"body":"Hello all,
I'm trying to convert a column of number ranges (formatted 0-10, 10-25) into the value of the range (10-25 = 15 etc.) Can anybody help me with a function to do this?
Additionally and even more helpful would be a function that can convert this number range column which is in cm (0-10) to a number range in inches (0-10 cm 0-3.937 in). If somebody can help me do one of these things it would save me buckets of time.
Best regards,
Owen
"},"Conversation:conversation:2221216":{"__typename":"Conversation","id":"conversation:2221216","solved":false,"topic":{"__ref":"ForumTopicMessage:message:2221216"},"lastPostingActivityTime":"2021-03-19T00:14:32.259-07:00","lastPostTime":"2021-03-19T00:14:32.259-07:00","unreadReplyCount":1,"isSubscribed":false},"ModerationData:moderation_data:2221216":{"__typename":"ModerationData","id":"moderation_data:2221216","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"Revision:revision:2221216_1":{"__typename":"Revision","id":"revision:2221216_1","lastEditTime":"2021-03-18T14:55:15.936-07:00"},"ForumReplyMessage:message:2221980":{"__typename":"ForumReplyMessage","id":"message:2221980","conversation":{"__ref":"Conversation:conversation:2221216"},"author":{"__ref":"User:user:403176"},"revisionNum":1,"uid":2221980,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"subject":"Re: Converting number range (0-10) to range value (10)","readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:2221980"},"parent":{"__ref":"ForumTopicMessage:message:2221216"},"body":"owenmyers27 Perhaps best demonstrated in a working example. See attached. I kept the \"helper cells\" in it, so that you can see the steps needed to come to the end result. Hope you think it's helpful.
","body@stringLength":"404","rawBody":"
