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.
[TABLE="width: 197"]
<tbody>[TR]
[TD]well 1
[/TD]
[TD]10
[/TD]
[/TR]
[TR]
[TD]well 2
[/TD]
[TD]10
[/TD]
[/TR]
[TR]
[TD]well 3
[/TD]
[TD]50
[/TD]
[/TR]
[TR]
[TD]Median
[/TD]
[TD]10
[/TD]
[/TR]
[TR]
[TD]Median + 1
[/TD]
[TD]11
[/TD]
[/TR]
[TR]
[TD]Vaiance
[/TD]
[TD]533.3333
[/TD]
[/TR]
[TR]
[TD]Variance/Median + 1
[/TD]
[TD]48.48485
[/TD]
[/TR]
</tbody>[/TABLE]

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!!!