nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Welcome!

% Variance between 2 numbers

mark.gipson27746

I am trying to figure out the % variance between 2 numbers ($40,190,187 and $40,279,091) I just need the formula can anyone help?

Find more posts tagged with

Healthcare

Formulas

Project Management

Comments

Ezra

Assuming you want the

subtract X from Y to get an absolute value "V"

get the MAX of "X" and "Y" [to get the greater of the two]

"V"/(MAX of "X" & "Y") [format this column as percentage ---- don't forget to increase your decimal place accuracy]

=ABS([Column2]21 - [Column3]21) / MAX([Column2]21:[Column3]21)

Jose Munoz

Ezra,

I did the calculation, but I get the value 1 instead of 100%, how can I increase the decimal place to show 100 in the formula?

Thanks for the help?

Ezra

Just change the column or cell to a percentage format (next to currency format in the top toolbar)

.25 = 25%

.5 = 50%

1 = 100%

Jose Munoz

Worked Thanks

melody.cooley71056

This is great; however, what if you needed to show the percentage of increase OR decrease?

Andrew Kuhn

we have the same question at Melody...

Tessa S

To see if it is an increase or decrease remove the abs( ) part of the equation. It is what makes everything positive.

=[Column2]21 - [Column3]21) / MAX([Column2]21:[Column3]21

This will allow the positive and negative values to show.

Sign in to join the conversation!

Quick Links

Trending discussions

Using HAS function with SUMIF - multiple references
Hi all, reaching out to see if of you have ideas; I'm hoping this makes sense: I'm having some trouble getting my formulas to pull data in correctly. I currently have a sheet (primary data) where I have data in rows where each row is a single project, with columns identifying persons, $ values, unique project identifier,…
Automated Messages Being Truncated- Does anyone have a workaround?
Hello, I have a workflow where, when a team member checks a checkbox, Smartsheet automatically sends an email to themselves containing merge fields that are used as a customer email draft. The challenge is that this activity typically happens on a deadline day, and a team member may need to generate 30 or more of these…
How to enlarge cell formula reference limit
I have a sheet with 5000 rows and 30 columns. with 4 columns of them are formular columns. How can i reach this limit for 25000000 formular cells reference? How can i enlarge this limit? I need those formular to link some data from another sheet as there is also Max cells limit for one sheet. How can I join those data…