Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range less than/.. min/max to a negative number..
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)) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range less than/.. min/max to a negative number..
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)) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range less than/.. min/max to a negative number..
Hi, think found answer, thought had tried this already.. but just having a
negative sigh "-" surround entire variable did inverse the item. too many numbers,, don't know if on right track anyways: 2 equations makes deviation.. max/min or min/max, using: ("-" sign now working, thanks). =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)) "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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Negative Number to Postive number | Excel Worksheet Functions | |||
count number of occurances of a word in a range | Excel Worksheet Functions | |||
How to sum data that is only within a specific number range? | Excel Worksheet Functions | |||
How to add one number to a range of numbers | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |