Excel Formula Explanation Required

choyaa

Hi,


I'm looking at a spreadsheet that someone else has setup, the following formula exists within it, can someone advise exactly what it means please?


=MEDIAN(IF(peer=$B3,IF(tcomp>0, tcomp)))

Annie1960

It may help if you could give some context. Is this for a t-test?

choyaa

Annie1960 wrote: »

It may help if you could give some context. Is this for a t-test?

It is for a sample test, the only context I can give is that it's a sample salary spreadsheet with cell B3 relating to the department of the employee.

droopsnoot

My guess is that 'peer' and 'tcomp' are named ranges in the spreadsheet, so if 'peer' is equal to the content of $b3, and tcomp is greater than zero, then it returns the median of the range of values in tcomp, otherwise it returns zero.


I'm not exactly sure how a named range 'peer' could equal a single cell value, but I'm not an Excel expert.

Annie1960

Do you know what tcomp refers to on the spreadsheet?

Le_Kirk

If you click on "Formula" on the menu tab and then on Name Manager, it should show you a list of defined names and/or ranges, hopefully amongst which you will find "peer" and "tcomp"

jackomdj

Agree with the named ranges, only thing to add tcomp range could relate to some kind of tax computation within the spreadsheet?

jackomdj

droopsnoot wrote: »

My guess is that 'peer' and 'tcomp' are named ranges in the spreadsheet, so if 'peer' is equal to the content of $b3, and tcomp is greater than zero, then it returns the median of the range of values in tcomp, otherwise it returns zero.


I'm not exactly sure how a named range 'peer' could equal a single cell value, but I'm not an Excel expert.

that single cell could itself be a calculation