% Variance between 2 numbers

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

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)

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?

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

.25 = 25%

.5 = 50%

1 = 100%

Worked Thanks

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

we have the same question at Melody...

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.

Cell value for main or subworkflows.
I am trying to create a formula or workflow that changes a cell value to a value in another cell. I tried with workflow, but I can only assign a text or specific value from a drop down. But I want to assign a value from a specific cell. Formula would help, but this then needs to change depending if the cell is already…
Returning multiple results for a cell with multiple values
I have two sheets: one is a form collection table and the other is a reference table. One of the fields (Code) entered in the form collection table will determine who is responsible for the request submitted. The Code cell can have multiple values (separated by a comma and space). It is possible to have multiple people…
Multiple conditions for counting
Super-basic question regarding COUNTIFS. I'm trying to return a value that shows me a count of projects from a certain year, for a certain client. =COUNTIFS((Project Number:Project Number), Contains("2025", @cell ),(Client:Client), Contains("ADV", @cell )) But this comes up as unparseable. Where am I going wrong?