E elsmith9035768 Member Mar 2, 2019 #1 How would I round this formula to the nearest $5,000? {=MEDIAN(IF(L58:L59>0,L58:L59))} Thanks
P Peter Bartholomew Well-Known Member Mar 2, 2019 #2 = MROUND( number, 5000 ) would do the rounding bit. I am not sure what the median of 1 or 2 numbers is going to achieve though.
= MROUND( number, 5000 ) would do the rounding bit. I am not sure what the median of 1 or 2 numbers is going to achieve though.
