How to take the highest of 2 numbers for division over the smaller

Hi all!

I have two columns I would like to divide, however, it has to be the high number divided by low number. See my attachment.

For example because FirstNew is a bigger number, it will have to be 5/3

However, in some cases the bigger number could be in FirstOld which would have to be 7/3

What would be the formula so that it will automatically pick the largest number to be divided by the smallest? Thank you!

Find more posts tagged with

Accepted answers

Kelly Moore

Hey @Robert K

Try this

=IF(AND(ISNUMBER(FirstOld@row), ISNUMBER(FirstNew@row)), IF(FirstOld@row >=FirstNew@row, FirstOld@row / FirstNew@row, FirstNew@row / FirstOld@row))

First, the formula checks to make sure both columns are populated then it checks to see if FirstOld is larger than FirstNew. If it is, it does the math, otherwise, it swaps to the opposite column as the numerator.

Will this work for you

Kelly

All comments

Kelly Moore

Hey @Robert K

Try this

=IF(AND(ISNUMBER(FirstOld@row), ISNUMBER(FirstNew@row)), IF(FirstOld@row >=FirstNew@row, FirstOld@row / FirstNew@row, FirstNew@row / FirstOld@row))

Will this work for you

Kelly

Robert K

Thank you Kelly! It works

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.