or is min / max, getting a different number supposed to be correct??, as in:
=IF(OR(BI9="",COUNTA(BJ9:BN9)=0),"",
IF(BI9<AVERAGE(BJ9:BN9),MIN(BI9:BN9)/MAX(BI9:BN9)%-100,MAX(BI9:BN9)/MIN(BI9:BN9)%-100))

"nastech" wrote:

Hello, I have a percent change equation with min/max being used that can not
figure out the easy way for showing it is a negative. (maybe shorter way for
positive half as well?) thanks

idea, not quite working ("-"& makes number text: get a long text number,
not rounded up/dn; min/max is not the same result)

=IF(OR(BI9="",COUNTA(BJ9:BN9)=0),"",
IF(BI9<AVERAGE(BJ9:BN9),"-"&MAX(BI9:BN9)/MIN(BI9:BN9)%-100,MAX(BI9:BN9)/MIN(BI9:BN9)%-100))