Dividing two formulas in excel

[davidjsmailbox]

Hello everyone,

I was wondering if you have a quick moment to help me with a formula in excel. We are trying to add a variance filter to our raw data and it would be really helpful to condense this into one formula.

We calculate our variance filter:
Triplicates with a variability >10 should be excluded

Ex.

well 1	10
well 2	10
well 3	50
Median	10
Median + 1	11
Vaiance	533.3333
Variance/Median + 1	48.48485

<tbody>
</tbody>

So in this case we would exclude well 3.

Formula?

VAR.S(C2:C4) & "/" (median(C2:C4)+1)

But that doesn't work

Thanks,

David

 

[63falcondude]

I cant help you with the 2 formulas that you want to divide but once you have those both working individually, simply use

=(formula1)/(formula2)

 

[Snakehips]

David, try.. =VAR(C2:C4)/(MEDIAN(C2:C4)+1)

 

[davidjsmailbox]

David, try.. =VAR(C2:C4)/(MEDIAN(C2:C4)+1)

Thanks!!worked!!!