| 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)) |
| 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 | |||
Threaded Mode
