-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How do I format cells to show GB, MB, KB
- Thread starter Dickison
- Start date
Nice. This works perfectly for positive numbers, but, predictably, always uses the MB scale for negative numbers. Is there a straightforward way to extend this to work with negative numbers? Apparently there's a limit to three ranges per custom formatter, so I fear this problem may be insurmountable, but I didn't know how to get this far until I discovered this thread. Thanks for any info.
(And, yeah, I know I'm replying to a thread that is 10 years old.
)
Upvote
0
Excel Facts
Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
