MODE

0 Comments , in

previous NEXT mode Number Divisor Remainder   12 5 2  =MOD(C4,D4) 20 7 6  =MOD(C5,D5) 18 3 0  =MOD(C6,D6) 9 2 1  =MOD(C7,D7) 24 7 3  =MOD(C8,D8) What Does It...
Read More

MEDIAN

0 Comments , in

previous NEXT median Value1 Value2 Value3 Value4 Value5 Median   20 50 10 30 40 30  =MEDIAN(C4:G4) 2000 1000 10 20 8000 1000  =MEDIAN(C6:G6) 10 20 40 40 40 40...
Read More

CONCATENATE

0 Comments , in

previous NEXT Concatenated Name 1 Name 2 Concatenated Text   Alan Jones AlanJones  =CONCATENATE(C4,D4) Bob Williams BobWilliams  =CONCATENATE(C5,D5) Carol Davies CarolDavies  =CONCATENATE(C6,D6) Alan Jones Alan Jones  =CONCATENATE(C7,” “,D7) Bob Williams...
Read More