Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula help
Hi,
I have a spread sheet set up so that some values are negative (this is so that they are included in "n", but not included in certain formulas) and i am trying to workout a formula that would calculate the median as if the values were positive. As it is a median value, it would not be appropriate to just times that answer by -1, and as the -ve values are not in a certain order, i can't use this method [ =MEDIAN(U12*-1,U13*-1,U14*-1 etc....] Spreadsheet example: U 1.2 1.9 -1.2 0.5 -1.9 I am not sure if this is even possible, but any help/suggestions would be appreciated Cheers Rehanna |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |