Formula - Order of Operations excel to smartsheets

Hello,

I am trying to get this math equation to work in smartsheet that normally working in excel and can't figure out how to do the proper order of operations. Can anyone help?

AN2 is the cell in excel I am pulling the number 15 into. Formula should = 0.06

=((AN2/86587))*30*1000/(90)

=([2025 Total]@row/86587))*30*1000/(90)

Find more posts tagged with

Formulas

Accepted answers

jpaul

Looks like you have an extra parenthesis. try the one below

=([2025 Total]@row/86587)*30*1000/(90)

All comments

jpaul

Looks like you have an extra parenthesis. try the one below

=([2025 Total]@row/86587)*30*1000/(90)

Mar_star

Thank you! You are right, it works now

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.